Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Table already exists in a database
Message
De
26/12/2006 14:54:40
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01180229
Message ID:
01180282
Vues:
16
>>>
>>>close table all
>>>close database all
>>>FREE TABLE resolutions
>>>
>>
>>Doing that and trying to add it back, gives an error "Table resolutions already exists in the database"...
>
>I am afraid, we are talking about different things. I answered the question assuming there is no table in the database because you could not add the table to the database using create .. from array command.
>If the table exists in the database, then use remove table command.
>
>As of why create ... from array does not work, then you probably already understand that with afield() you create an array having long name of the table (array column 12). Thus, with the create .. from array you attempt to create another table having the very same long name. And it is not allowed.
>But with COPY command you cretae the free table and you may then add it to database.

COPY TO command not only creates a table but it may also add it to a database.
Edward Pikman
Independent Consultant
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform