Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Table already exists in a database
Message
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:
01180281
Views:
17
>>>
>>>close table all
>>>close database all
>>>FREE TABLE resolutions
>>>
>>
>>Doing that and trying to add it back, gives an error "Table resolutions already exists in the database"...
>
>I am afraid, we are talking about different things. I answered the question assuming there is no table in the database because you could not add the table to the database using create .. from array command.
>If the table exists in the database, then use remove table command.
>
>As of why create ... from array does not work, then you probably already understand that with afield() you create an array having long name of the table (array column 12). Thus, with the create .. from array you attempt to create another table having the very same long name. And it is not allowed.
>But with COPY command you cretae the free table and you may then add it to database.

With the COPY command you can create a table as part of a database. Anyway, somehow I damaged this database and now I'm struggling trying to fix it.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform