Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Bad meta data causing .DBF/.CDX corruption?
Message
 
To
10/01/2003 11:33:05
General information
Forum:
Visual FoxPro
Category:
Stonefield
Miscellaneous
Thread ID:
00738378
Message ID:
00740355
Views:
14
>>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-
Previous
Reply
Map
View

Click here to load this message in the networking platform