Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem adding a new table to a database
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01401573
Message ID:
01401574
Views:
63
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform