Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Bad meta data causing .DBF/.CDX corruption?
Message
 
À
10/01/2003 11:33:05
Information générale
Forum:
Visual FoxPro
Catégorie:
Stonefield
Divers
Thread ID:
00738378
Message ID:
00740355
Vues:
15
>>I've found that some SDT metadata has gotten fouled up somehow: one particular table has it's 4 index tags listed but contains no content for the 'expression' when viewed by the SDExporer.
>>
>>What I've found, after Reindex(), is that the .DBF doesn't "see" the .CDX for the table in question.
>
>Actually, that makes sense. The first thing Reindex() does is nuke the CDX file. It then tries to recreate the indexes, but fails since the expression is empty. It should return .F. in this case (are you checking the return value?).

Yep, I'm checking it. I've got IF/ELSE/ENDIF code like:
IF oMeta.oSDTMgr.Reindex('ALL', .T., .T.) .AND. oMeta.oSDTMgr.Reindex('!ALL', .T., .T.)".

The ELSE portion *would* present a MESSAGEBOX() except, apparently, the app locks during the IF expression(s) because the user hasn't reported seeing the MESSAGEBOX(). Just that "it won't run."

FWIW, after getting the data back in order I corrected the metadata, ran the STD code and it would seem all-is-well. Maybe I should keep a ZIP of the metadata handy? And would this ZIP then qualify as meta-meta-data? :)

Thanks Doug,
Steven-
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform