General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>> use yourTable
>> copy to yourpath\yournewtable.dbf database yourDATABASE with CDX
Thanks to you and others for alterting me to the DATABASE parameter in VFP's COPY TO command (guess I should read the manual someday). In this case I only wanted to change what database the table was in, not move or rename it, so I COPY TO'd it to the same folder WITH PRODUCTION and the new DATABASE name, deleted the original, opened the new database and did a RENAME TABLE to rename the copy back to the orginal's name. There's probably an easier way but this one seemed to work.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only