Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to Add a Key to a Database Programatically
Message
From
21/09/2015 04:22:11
 
 
To
20/09/2015 20:28:50
John Ryan
Captain-Cooker Appreciation Society
Taumata Whakatangi ..., New Zealand
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 8
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01624844
Message ID:
01624864
Views:
47
Thank you for answering.

This is my problem. The table is in a DBC. I INDEX ON fieldname TAG tagname and do a VALIDATE DATABASE after that. And the VALIDATA gives an error saying that the index is not in the Database.

Next I will try to explicitly SET DATABASE TO before I do the INDEX ON.

TIA
Gerhard

>>>The mesage comes up when I do a VALIDATE DATABASE. I would like to prevent this message by adding the index definition to the DBC. But I do not know how.
>
>If the table is in a DBC and you add a table index, the index ought to be in the DBC. Is there something else going on?
Gerhard Schmidbauer
URANUS Software GmbH
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform