Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
>>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.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement