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:
01180233
Views:
17
>>Hi everybody,
>>
>>I've created a table in a database with AutoInc field called Problems. I then wanted to create a table with the same structure in the same database called Resolutions. I did
>>
>>=afields(laProblems)
>>
>>CREATE TABLE ..\Data\Resolutions FROM ARRAY laProblems
>>
>>This gave me an error about an object already exists. I then downloaded ArrayBrowser and examined the array. I found PROBLEMS in 12th column first row. I changed it to RESOLUTIONS, but now I'm getting the table Resolutions is already part of the database error. But it is not there and INDBC returns .f. as well.
>>
>>Other than using database files as a table is there a way to fix the problem?
>>
>>Thanks in advance.
>
>Ok, I didn't find this table in the database itself after browsing it as a table. So I went to the DATA directory, deleted the file and was able to add the table to database with the CREATE TABLE command. However, I do not see this object in the database container even after I arranged them by name. INDBC reports .t.
>
>Weird.


Most likely it is located under another object, and you cannot see it unless you move the object that is on top.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform