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:
01401574
Vues:
65
This message has been marked as a message which has helped to the initial question of the thread.
>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....
ICQ 10556 (ya), 254117
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform