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:
01180231
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.
close table all
close database all
FREE TABLE resolutions
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform