[net.micro.pc] JOIN "anomaly" in dBASE III

carters@tektronix.UUCP (Carter Stein) (10/12/84)

<*>
The dBASE III join command does not work as documented (pg. 4-60 of dBASE III
users manual).

The problem is that ALIAS names after the FIELDS keyword are not recognized by
dBASE III.  For example:

                                                        ? 
JOIN WITH <alias> TO <.dbf-file> FOR <condition> FIELDS <alias>-><fieldname>

causes a syntax error.  The question mark above, marks the location of the 
syntax error.

The work around for this problem is as follows:
	1.  Issue the JOIN command without using the FIELDS keyword.
	2.  USE the resulting table
	3.  Issue a "COPY TO <dbf-file> FIELDS <field-list>" command to
	    create the table with the needed fields.
===============================================================================

By the way,  does anyone know where I can get a copy of the program PCFILE3?

Please e-mail responses to me at tektronix!carters.

Thanks

carter stein