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:
01401576
Views:
48
>>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
Previous
Reply
Map
View

Click here to load this message in the networking platform