Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Error when rebuilding index using SDT
Message
De
18/12/2006 08:15:11
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Stonefield
Versions des environnements
Visual FoxPro:
VFP 9 SP1
Divers
Thread ID:
01178286
Message ID:
01178515
Vues:
11
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform