Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Table already exists in a database
Message
From
26/12/2006 13:47:20
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01180229
Message ID:
01180258
Views:
24
This message has been marked as the solution to the initial question of the thread.
>>In any case, if indbc() returns .t., and the table physically exists as a file, then no doubt it should be in the database container, but it is hidden somehow in the database viewer. To see the table object there, try this:
>>- copy *.db* files to test directory;
>>- set default to test directory;
>>- modify (yourdatabase), and review it in the database viewer;
>>- remove objects from the database one by one and see if the object you need appears.
>
>Yuri,
>
>I've done that and the table didn't appear and moreover Arrange and Find Object menus are now greyed out. I think there is no other way as to try to free the table and re-add it. I'll lose all my long names, but I can re-create them again, I think.
>
>Thanks again for your help. It just shows that you need to be careful using CREATE TABLE FROM ARRAY ... and always examine the array first.

Can you just use COPY TO command ?
Edward Pikman
Independent Consultant
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform