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 08:48:21
 
 
To
21/09/2015 04:22:11
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:
01624872
Views:
57
SET DATABASE TO before I do the INDEX ON solved the problem. It seems I changed the database somehow before indexing.


>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
Reply
Map
View

Click here to load this message in the networking platform