>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.
If it's not broken, fix it until it is.
My Blog