Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Table already exists in a database
Message
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Table already exists in a database
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01180229
Message ID:
01180229
Views:
64
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.
If it's not broken, fix it until it is.


My Blog
Next
Reply
Map
View

Click here to load this message in the networking platform