General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only