Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error when rebuilding index using SDT
Message
From
18/12/2006 08:15:11
 
General information
Forum:
Visual FoxPro
Category:
Stonefield
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01178286
Message ID:
01178515
Views:
10
This message has been marked as the solution to the initial question of the thread.
Hi Dmitry.

>UPDATE: I found the table the causes the Error 10 Syntax Error.
>The table has 0 records. When I Validate Database I get messages that seem to point to missing index tags for this table. Then I Validate Table Recover and choose to delete the missing objects. But as soon as I try to Reindex this table, the problem (Error 10 and Object not found in Validate Database) reoccur. Still mystery.

If you remove indexes using VALIDATE DATABASE RECOVER, the SDT meta data and DBC are no longer in sync, so you can't really use SDT until you resync them (click the Validate Meta Data button in the SDT Database Explorer or use oMeta.Validate).

>>If I select/check each table one at a time, Reindex works fine. But if I check All Tables, I get error 10 Syntax Error. It is hard to see which table causes this error. But by closely watching the screen it goes almost to the very last table.

You can include oMeta.oSDTMgr.cAlias in your error message to see which table is failing.

Doug
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform