>I want to copy certain records to a file so that the file is a member of the same database, so VFP3.0 won't truncate the names of the fields in the file. I read somewhere that this can be done using a command similar to: "copy to in ,database name>. Does anyone know what the command is?
>
>Thanks,
>
>Alan

Josh has the syntax right. Copying a table to a new database will preserve the field names, but lose the other extended information (caption, comment, inputmask, etc.)

To preserve this stuff (if you care) download my GenTable utility here and use it to create complete programmatic definition of your table, and then run that definition on the new database. You can then APPEND whatever records.

Erik Moore
Clientelligence