Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problem adding a new table to a database
Message
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
Network:
Windows 2003 Server
Database:
MS SQL Server
Divers
Thread ID:
01401573
Message ID:
01401576
Vues:
50
>>Hi everybody,
>>
>>I have this code
>>
>>set database to myDatabase
>>if not indbc('PO','TABLE')
>>   llContinue = CreatePOTable()
>>endif
>>
>>On attempting to create this table I'm getting this error
>>
>>File fullpath\po.dbf already exists as part of a database.
>>
>>but when I try to use a table I don't see this table as part of the database.
>>
>>What may be wrong here and how can I fix the problem?
>>
>>Thanks in advance.
>
>try this:
>FREE TABLE PO.DBF
>
>....then try to add it again....
>Keep in mind if you have long fieldnames the FREE TABLE command will truncate them....

Thanks, Victor. I already fixed the problem by freeing the table, deleting it and re-creating.
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform