HDTenEightyP/NetNews huggingface dataset:
From: lars@nl-halvorsen.jsc.nasa.gov (Lars Halvorsen)
Subject: FoxBase+ books?
Followup-To: comp.databases
Organization: Krug Life Sciences, Inc.
Date: Wed, 7 Oct 1992 12:38:48 GMT

Does anyone know of any good books for a beginner to FoxBase+ on the PC? 
My dad bought FoxBase+ for his PC a while back (before Microsoft took over
the FoxBase products), but having very little experience in programming and
no experience in databases, he's looking for a book that can help him get
started. 

I remember seeing books on FoxBase+ some years ago, but all I can find now
are books on the latest versions of FoxBase PRO. But since FoxBase+ does
all he needs and more, he's not very interested in upgrading to the latest
and greatest; he just needs a book to get started with the version he has.

Any suggestions as to which book(s) to look for and where would be greatly
appreciated.



+--------------------------+---------------------------------+
| Lars S Halvorsen         | lars@nl-halvorsen.jsc.nasa.gov  |
| Krug Life Sciences, Inc. | halvorsen@medics.jsc.nasa.gov   |
| Houston, Texas           | AppleLink : LARS                |
|                          | CIS : 75100,44     AOL : LarsH  |
+--------------------------+---------------------------------+
Newsgroups: comp.databases
From: adrie@gouldnl.encore.nl (Adrie van Hoogstraten)
Subject: DBASE IV error codes listing
Organization: Encore Computer Nederland BV
Date: Tue, 13 Oct 1992 08:55:44 GMT


Does anyone on the net have an error code listing of DBASE IV. Or does anyone
know where I can ftp one from? I keep getting the internal system error 1530
message whenever I try to change to the report of forms generator.

Thanks very much.

Adrie van Hoogstraten
email: ahoogstraten@encore.nl

Newsgroups: comp.databases
From: fredg@ariel.yorku.ca (Fredrick Gonsalves)
Subject: Re: Clipper Windows Version
Originator: fredg@juno.ariel.yorku.ca
Organization: York University, Toronto, Canada
Distribution: york
Date: Wed, 14 Oct 1992 13:54:09 GMT


In article <1992Oct12.133816@axion.bt.co.uk>, jpennell@axion.bt.co.uk (John Pennell) writes:
>> 
>> 
>> I'm not sure, but isn't ASPEN (clipper for windows?) been purchased outright by Computer Associates???
>> 
>> Jon

I think that ASPEN is also an OODB.  They are in the testing phase (I think)
and say it will still take time to come out. 

FredG
YorkU, Canada
From: rpress@bizhost.wariat.org (Richard Pressl )
Newsgroups: comp.databases
Subject: Looking for Viewer for xBase DBF on Netware
Date: Thu, 15 Oct 92 13:28:23 EDT
Organization: CMDA, Euclid, OH


        Just curious if anyone can suggest a Shareware or in-expensive
DBF Viewer to run on our Novell 3.11 (20 node) LAN? We currently use
Foxpro SU, Paradox, Q&A, and PC File to create/append names/addresses
to a DBIII+ style DBF; but we want a *SIMPLE* viewer/locator for our
department. Once successful on our LAN, we would urge the other LANs on
our backbone network, (6 servers - 400 nodes) to use the viewers as well.

        Kaya's DBView is about as complex as it needs to be. The older
DBXL is about max on the complexity scale. Any suggestions short of a
custom written app.
...

rpress@bizhost.wariat.org     Fido 1:157/562
Richard Pressl: Commercial Micro Data Analysts: UCC-OC, Cleveland
SysOp: Bizhost BBS: +1 216 731 4769   Searchlight/Waffle/HST-DS
Newsgroups: comp.databases
From: mikes@ars2.uucp (Mike Schlosser)
Subject: Re: We need dBaseIV help!
Organization: Automated Retail Systems, Seattle, Wa
Date: Fri, 9 Oct 1992 20:15:48 GMT

In <1992Sep28.163538.1@ulkyvx.louisville.edu> cl130000@ulkyvx.louisville.edu writes:


>  We are having some trouble with dBase IV.  First, does this version support
>the mouse?  If so, how do you activate it.  The mouse is connected and the
>software is in memory.  Second, when working with the DATE data type, how do
>you enter null values into the year?  We need to enter something like '**'
>because some people don't want us to know how old they are.  Any help would be
>greatly appreciated.

>Thanx, in addvance.

>dBase Pros! (not!)
>cl130000@ulkyvm.louisville.edu

I don't know about mice but I can help with the birthdate problem.

YOU CAN'T DO THAT !!!

If you use a date type field, a year IS required. 
I suggest using number fields for the month, day, and year with valid 
clauses for each. This way they can leave the year blank.
Don't forget Feb 29 is OK if int(year/4) = year/4.

You can then store this info into a date field, for indexing or whatever,
using something like "1492" for the year.

GOOD LUCK

-- 
  Mike Schlosser <mikes@ars2.UUCP> |Voice:(206)325-8922| AI: The Art Of Making
  Automated Retail Sys., Seattle   |FAX  :(206)325-9127|     Computers As 
  R & D,  Programmer/Analyst       |Standard Disclaimer|     Stupid As Humans.
Newsgroups: comp.databases
From: durai@ORTTA (Appadurai V.)
Subject: Re: FoxBase+ books?
Organization: U of Mn
Date: Wed, 7 Oct 1992 13:15:48 GMT

In article <lars-071092072915@nl-halvorsen.jsc.nasa.gov> lars@nl-halvorsen.jsc.nasa.gov (Lars Halvorsen) writes:

>Does anyone know of any good books for a beginner to FoxBase+ on the PC? 
>My dad bought FoxBase+ for his PC a while back (before Microsoft took over
>the FoxBase products), but having very little experience in programming and
>no experience in databases, he's looking for a book that can help him get
>started. 

>I remember seeing books on FoxBase+ some years ago, but all I can find now
>are books on the latest versions of FoxBase PRO. But since FoxBase+ does
>all he needs and more, he's not very interested in upgrading to the latest
>and greatest; he just needs a book to get started with the version he has.

>Any suggestions as to which book(s) to look for and where would be greatly
>appreciated.



>+--------------------------+---------------------------------+
>| Lars S Halvorsen         | lars@nl-halvorsen.jsc.nasa.gov  |
>| Krug Life Sciences, Inc. | halvorsen@medics.jsc.nasa.gov   |
>| Houston, Texas           | AppleLink : LARS                |
>|                          | CIS : 75100,44     AOL : LarsH  |
>+--------------------------+---------------------------------+


There are several books.  I would recommend the one by Les Pinter.  
Unfortunately I do not remember the title.  You may want to call or write to 
Pinter Consulting.

Pinter Consulting
PO Box 1324
Menlo Park, CA 94026-1324.
(415) 325-7953

If you want a better suggestion, migrate to Foxpro.  You can avoid repeating 
the learning curve experience.  (and there are tons of good books..)
Xref: sparky comp.databases:7163 comp.databases.oracle:1806
From: pihlab@hhcs.gov.au
Newsgroups: comp.databases,comp.databases.oracle
Subject: ORACLE<>INTERLINK<>ORACLE
Date: 12 Oct 92 09:14:01 +1000
Organization: Aust. Dept. Health, Housing and Community Services

AHHHHHHHHHHHHHHHHHHHHHHHHHH!!!!!!!!!!!!!!!!!!!!

I just spent 11 hours trying to move data from VMS to MVS via an INTERLINK
gateway box.  Much as I like the double-time overtime money I am really
getting !@#$%^&*'ed OFF.

Heeeeeeeeeeelp.

Is there anybody out there using ORACLE and INTERLINK successfully?

Is there anybody out there using INTERLINK at all?

I'm having communications links that run successfully for a random time
and then suddenly drop out with a communication break for no apparent
reason.

  IMP-00003: ORACLE error 6402 encountered
  ORA-06402: NETCMN: error receiving break message

I'm running Oracle V6.0.34 (VMS) and V6.0.33 (MVS).
 
Our Systems Programmers (MVS) say its an INTERLINK problem.
Our Communications people say its an ORACLE problem but as far as I can tell
they don't have ANY tools to monitor whats happening in the INTERLINK box.
Our Systems Programmers (VMS) say its a Communications problem.

I say its an INTERLINK problem.

The same job run INTERACTIVELY and in BATCH works INTERACTIVELY every time
and intermittently in BATCH!  The VAX Batch job has same resource settings
as interactive session.

-- 

Bruce...        pihlab@hhcs.gov.au
                 ^^
*******************************************************************
* Bruce Pihlamae  --  Database Administration                     *
* Commonwealth Department of Health, Housing & Community Services *
* Canberra, Australia                             (W) 06-289-7056 *
*******************************************************************
* These are my own thoughts and opinions, few that I have.        *
*******************************************************************
Newsgroups: comp.databases
From: jpennell@axion.bt.co.uk (John Pennell)
Newsgroups: comp.databases
Subject: CLIPPER - Indexes, arggggh!
Date: 15 Oct 92 08:59:56 GMT
Reply-To: jpennell@axion.bt.co.uk (John Pennell)
Organization: British Telecom Research Labs



I have tried everything I can think of

I have an application under 5.01 which has 14 databases open,
18 indexes and around 1400 files in each base.  I am not using
SET relation, but performing the links between them with recursive seeks.

The problem is that every so often, the indexes stop showng the
real contents of the database.  This has been solved by REINDEXing the
databases every time the application is launched.  This is not very
satisfactory.

The system is running on a peer-to-peer network (NetWare Lite), but did the
same thing working as a stand-alone system.  It is now running under DR-DOS 6.0,
but is no better using MS-DOS 5.0.

Any suggestions?

Jon
Newsgroups: comp.databases
From: michaelh@g2syd.genasys.com.au (Michael Haldey)
Subject: Re: Clipper file creation problem
Organization: Genasys II, Sydney, Australia
Date: Fri, 16 Oct 1992 06:38:44 GMT

In article <1992Oct14.004256.16706@kum.kaist.ac.kr> shkang@dari.gsc.co.kr (Sungho Kang) writes:
>
... program is ommited ...
>
>
>-------------------------------------------------------------
>( I use Clipper5.01 and MSC 6.0 )
>
>I have two problems in above code.
>
>	1. error message : " cannot create VM swap file "

You have not enough disk space. Swap file may be quite large and it's
created in TMP directory. SET TMP to point to somewhere with enough space.

>
>	2. I know that can open files to 255 in Clipper 5.01.
>	   Now I open 12 files, but I got error message "fopen() error message"
>	   When link Clipper obj and C obj, this rule ( 255 files open ),
>	   Is this rule invalid ?
>

No. You can open simultaneously as many files as allowed by config.sys
and SET CLIPPER F:<n> statement.

>	   Please help me!!!.
>

my 0.02

michael
-- 
Michael Haldey  |  Genasys II Pty Ltd
                |  13th Level, 33 Berry St, North Sydney, NSW, Australia
                |  Phone:    +61-2-954-2878 (-9930 FAX)
                |  Internet: michaelh@g2syd.genasys.com.au
Newsgroups: comp.databases
From: durai@ORTTA (Appadurai V.)
Subject: FoxPro 2.0 book
Organization: U of Mn
Distribution: na
Date: Wed, 14 Oct 1992 19:23:41 GMT

I left out this one...

Title              Author          Publisher     Price      How good

Pros talk Fox      6 different     Pinnancle     169 or     Good, but
series             people, 6                     109        costs too much
6 diff volumes     different                     (ask for   for what is
                   topics                        spl rate)  offered  


 My opinion, please.
Newsgroups: comp.databases
From: wesleyl@genghis.borland.com (Wesley Leung)
Subject: Re: dbase IV format file
Originator: wesleyl@genghis.borland.com
Organization: Borland International
Date: Thu, 15 Oct 1992 20:36:35 GMT

>I am a format file to do multi record editing on a
>file called customer, as shown below
>
>USE customer
>SET FORMAT TO cust_fmt
>EDIT
>SET FORMAT TO
>
>However, I need to perform some commands after each record is
>edited. Where should I insert the commands? Adding them in the
>format file don't seem to work.

There are many ways of doing this, it just depends on when you
wnat to execute these commands.  If it is during the EDIT you can
use either the "Permit edit if"(WHEN clause) or "accept
value"(VALID clause) in the FORMAT file.  If it is after the edit
you can put a UDF() in the "permit edit if" of the first field of
the format file.  However I would rather suggest the following:

USE customer
mFirst=.T.
SET FORMAT TO cust_fmt
Do WHILE mFirst .OR. LASTKEY()#27     &&LASTKEY()#27 is for ESC
  EDIT NEXT ONE
    your commands
	:
	:
  SKIP
ENDDO
SET FORMAT TO

GOOD LUCK!

Wes,<disclaimer>
-- 
Wes,
Xref: sparky comp.databases:7131 comp.databases.oracle:1783
From: rlbright@nrchh010.NoSubdomain.NoDomain (Ronald Albright)
Newsgroups: comp.databases,comp.databases.oracle
Subject: Omnis 7
Keywords: Omnis,Blyth
Date: 8 Oct 92 15:54:17 GMT
Followup-To: comp.databases
Organization: Northern Telecom





   I'm looking for information and opinions on a database product from Blyth
Software called Omnis 7. The front end looks good but I haven't seen any of
the driving software for generating the forms and formulas for derived fields.
Also I was told the forms could be used as a front end for entering and
maintaining data in an Oracle database. If anyone has used this I would 
appreciate some opinions on capabilities and ease of use of this product.


Thanks,
Ron Albright
 
Newsgroups: comp.databases
From: mazzucch@ghost.dsi.unimi.it (massimo mazzucchi)
Subject: CLIPPER_SCANNER
Keywords: clipper and scanner
Organization: Computer Science Dep. - Milan University
Date: Wed, 7 Oct 1992 12:51:42 GMT


Hi

I am a programmer with CLIPPER
i want know

- what is the library that permit to use image with scanner
  with clipper

  - what is the bbs where i can have to access to get
    this librAry


    Thanks for your help

    My address is mazzucch@ghost.sm.dsi.unimi.it


    Bye
Newsgroups: comp.databases
From: joet@dcatlas.dot.gov (Joe Trott)
Subject: Re: RBASE: Does is still exist as a development platform?
Organization: U.S Dept. of Transportation
Date: Wed, 14 Oct 1992 20:18:49 GMT

adye@boi.hp.com (Alan Dye) writes:


[About Rbase:]
>(The question now, is who will buy it if it does go on the block...
>  Microsoft? -Microrim is located on the corner of their corporate 
>  campus-
Yes, but they did just get FoxPro, and will probably stick with xBase.

>  ...Lotus? -they don't have a database package, a glaringly 
>  obvious ommission for such a large software house
Doubtful.  Lotus seems to be especially busy on Email related development,
so I'm not sure that Rbase would fit anywhere in their corporate strategy.

>  ...- WordPerfect?
>  -They could sure use something besides dataperfect
My understanding was that WordPerfect was being wooed by Borland into
working out some good integration with Paradox and Quattro Pro.  Personally,
I think that would be *excellent*; I'd buy such an integrated offering
without hesitation.

-  Enquiring minds should feel free to speculate.
...as I am doing.

-JTT
Newsgroups: comp.databases
From: robert@wixer.cactus.org (Robert Cope)
Subject: dbase report's..
Organization: Real/Time Communications
Date: Wed, 14 Oct 92 04:14:13 GMT

I was wondering if someone knew of an ftp site where I could get a shareware
or freeware report form editor (.FRM files).  Many thanks..

robert
-- 
Robert Cope                             If I had anything useful or funny to
cactus.org!wixer!fence!robert           to say, it would probably be on these
robert@fence.cactus.org                 three lines.  But I don't.
From: rhaven@cruzio.santa-cruz.ca.us
Newsgroups: comp.databases
Subject: Re: Paradox Help
Summary: How to mark on a form
Date: Tue, 13 Oct 92 22:37:04 PDT
Reply-To: rhaven@cruzio.santa-cruz.ca.us

In article <Oct.13.14.33.31.1992.28260@andromeda.rutgers.edu>, banerji@andromeda.rutgers.edu (Ranjan Banerji) writes:
> I am using a form in the Wait record loop. A part of the form is
> marked using a bar.(To mark a choice). However when you move to next record
> and then come to the one you just marked the marking is no longer there.
> This is because the Wait record command clears the screen of any paint canvas
> paint(if I may call it so). I cannot insert the paint canvas after the wait
> record. So how do I keep the choice marked when I leave it and come back 
> to it.
> 
> Thanks
> 
> Ranjan


One way is to place a calculated field that evaluates to something like:
       IIF(IsAssigned(dynary[[Key Field]]),"*"," ")
and when they indicate they want to mark or unmark the field, your PAL code
assignes or releases the appropriate dynarray element.  This only works in
Paradox 4.0 and takes a little understanding about dynamic arrays.  They are
arrays that have string values for indexes instead of numbers.  You can
create a dynamic array element simple by making an assignment (e.g.
dynary["12345"] = "green")  Using IsAssigned(), you can check to see if
a particular dynarray index exists.  Dynamic arrays are also called "bags"
because you can stick anything in them, including memo-length text (i.e.
256 characters up to 64 megabytes).  

This technique uses dynary to keep track of which records have been 
marked and which have not.  It does require, however, a unique value
for each record (e.g. the key) for identification.

There are some techniques for painting on the canvas, but it is better to
work with Paradox than trying to force it.

Cheers
From: rhaven@cruzio.santa-cruz.ca.us
Newsgroups: comp.databases
Subject: Re: Paradox database corruption
Summary: How to avoid file corruption in Paradox 3.5
Date: Thu, 08 Oct 92 22:22:26 PDT
Reply-To: rhaven@cruzio.santa-cruz.ca.us
Distribution: comp



NEVER TURN OFF YOUR PC IN THE MIDDLE OF AN OPERATION.  This is just
good general practice.  If you are using Edit mode, this is absolutely
vital.  CoEdit is the preferred mode for a lot of reasons.

There is a program named TUtility included with your copy of Paradox 3.5.
It is specifically for recovering corrupted tables.

Paradox 4.0 is a newer and more powerful database, but if you shut down or
reboot the system in the middle of things, nothing will save you.

Cheers
From: rao@cs.mu.OZ.AU (Kotagiri Ramamohanarao)
Newsgroups: comp.databases
Subject: VLDB Journal Special Issue on Prototypes of Deductive Database Systems
Date: 16 Oct 92 03:01:33 GMT
Article-I.D.: mulga.9229013.8600
Reply-To: rao@cs.mu.OZ.AU (Kotagiri Ramamohanarao)
Organization: Computer Science, University Of Melbourne, Australia
Originator: rao@munta.cs.mu.OZ.AU


Keywords: deductive databases, logic programming, knowledge-based systems


			Call for Papers


The VLDB Journal  Special Issue on Prototypes of Deductive Database Systems



The VLDB Journal is planning a special issue on Prototypes of Deductive
Database Systems. Potential authors are encouraged to submit original
papers describing prototype deductive database systems. Papers should
address the issues below.


  o Query and Update Language Description

  o Computational Model

  o Optimisation Techniques

  o Implementation and System Architecture

  o Performance Measurements

  o Applications


Potential authors are encouraged to submit original, journal quality papers
to the special issue editor.


      Professor Kotagiri Ramamohanarao          Fax: +61 3 282 2444
      Department of Computer Science            E-Mail: rao@cs.mu.oz.au
      University of Melbourne
      Parkville, 3052
      Victoria, Australia



  Send 6 copies of a complete manuscript of no more than 35 type-written, 
double-spaced pages.  For more specific information see the Guidelines 
for Manuscript Preparation of the VLDB Journal which can be obtained through 
the special issue editor or the responsible editor-in-chief Hans J. Schek
(schek@inf.ethz.ch). All papers will be reviewed through the Journal's
editorial board.

Important dates:


     March 1, 1993            Due date for manuscript
     June 1, 1993             Notification of acceptance
     August 1, 1993           Due date for final revised version


A preliminary statement of your intention to submit would be appreciated.
Newsgroups: comp.databases
From: ejnall@sacam.OREN.ORTN.EDU (Earl J Nall)
Subject: Re: FoxPro newgroup/mailing list exist ?
Organization: Oak Ridge National Laboratory
X-Newsreader: Tin 1.1 PL5
Date: Tue, 13 Oct 1992 13:09:05 GMT

Was there a response to the FoxPro list?
From: glenn@sw.stratus.com (Glenn Butler)
Newsgroups: comp.databases
Subject: Clipper 5.01a VMM + Windows 3.1 = crash?
Keywords: Clipper
Date: 13 Oct 92 14:07:10 GMT
Organization: Stratus Computer, Inc.

Howdy all,

My clipper applications don't like to run in windows sessions - especially
when conventional memory is low or when using the clipper debugger (which makes
memory low).  Windows traps the application with either a invalid instruction, or
invalid memory refernence and terminates the session.  Windows 3.1 ios running in
386 enhanced mode.

I'm assumming that this is because of Clipper's virtual memory management is
using some kludgy scheme to manage memory that pisses off windows.

Here are my questions:  Does anyone else experience this, and is there something
that I can do to the clipper runtime environment to fix this or at least make
it less likely - maybe something to do with the way clipper uses swap files and
extended memory??  Right now it doen't happen that often, but it is becoming more
common as my app grows in size.

Also, is anyone doing Clipper DOS development under OS2 2.0?  Does this problem
happen here to (I assume OS2 2.0 would trap and crash a clipper app as well).
Are there any other problems/comments about Clipper development under os/2 2.0?

Thanks in advance,

Glenn
Newsgroups: comp.databases
From: ramirez@IASTATE.EDU (Richard G Ramirez)
Subject: Re: Hints for OCELOT needed
Reply-To: ramirez@IASTATE.EDU (Richard G Ramirez)
Organization: Iowa State University
Date: Thu, 15 Oct 1992 16:39:26 GMT

I don't know OCELOT but from what I have read
its major competition is QUADBASE/SQL which I have.

Quadbase is an SQL engine that is callable from
C, Basic, and (many) other languages.

As a SQL engine, it does little other than allow you
to write SQL statements from the language of your choice.
As far as I can tell, its version of SQL is very complete,
similar to Oracle (which I also use).  Queries run
very fast but I don't have any experience with large
tables.  Most of my tables are a few hundred rows.
They claim their performance exceeds most other databases
and certainly it is not a cheap product.

I moved to Quadbase because Oracle requires too much memory
and disk space and does not run well under Windows.

The downside is that you cannot run simple queries and 
look at the result without writing a complete program.
To be fair, Quadbase and I assume Ocelot too provides
a visual frontend that lets you run queries.  It is not bad
but it is very difficult to print the output.
It is also difficult to run a series of statements,
most of the time you have to run them one by one.

A good thing is that it read and writes dBase tables,
making it compatible with a lot of other software.
Newsgroups: comp.databases
From: calb@edsi.plexus.COM (Calvin Bolwerk)
Subject: Novice question
Organization: Enterprise Data Systems Incorporated, Appleton WI
Date: Thu, 15 Oct 1992 10:30:21 GMT


I am a little new to programming databases.  I am getting ready to 
purchase some software at work so that we can keep track of 
equipment that we have in the plant.

What I am wondering is if there are programs out there that will 
allow the programmer to create a stand-alone (ie .exe) program 
without having to program in C or some other language.  I 
understand that programs like Paradox will allow you to create 
applications, but it still requires Paradox to run the 
application.  I would like to be able to create the program and 
then give it to say the maintenance department and they could run 
it without them having to purchase a database program also.

Is this possible?

Thanks for the help!
Newsgroups: comp.databases