>>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only