Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CREATE TABLE does not seem to work all of the time
Message
 
General information
Forum:
Visual FoxPro
Category:
FoxPro 2.x
Miscellaneous
Thread ID:
00191904
Message ID:
00192015
Views:
48
>>The programmer is renaming an existing file. Here are the steps she is taking:
>>1. Renames Control.dbf to Control1.dbf
>>2. Creates an empty table named Control.dbf
>>3. Appends records from Control1.dbf into Control.dbf
>>4. When a program tries to use Control.dbf, the error message occurs.
>
>After you append the records, you have to close the table then reopen it for shared access. The CREATE TABLE automatically opens the new table as EXCLUSIVE.

Sorry, lost sight of original problem. Is the problem really intermitent and not constant? If the problem is not persistent, then I suggest going with my first suggestion of testing the existence of the table after creating it, and maybe adding an error trap for that error number.
Mark McCasland
Midlothian, TX USA
Previous
Reply
Map
View

Click here to load this message in the networking platform