Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Syntax to break a dbf from it's cdx.
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00317076
Message ID:
00317121
Views:
17
>>>I have an unattended reindexing routine. Sometimes it's got a cdx that is FUBAR. how do you breke the connection in the dbf to the cdx?
>>>
>>>I have Stonefield but that is user over ride and thei is really a com server app. I cannot have error conditons which ask for user intervention.
>>>
>>>TIA
>>>
>>>__Stephen
>>
>>
"Delete tag all" or alternatively you could delete the CDX file (when you attempt to "use" it would complain "Structural CDX not found" - ignore).
>>PS:Might be a duplicate message - I got a message from UT interface to resend.
>>Cetin
>
>
>Delte tag all is fine if it opens, but when the cdx is blown, I need to get a low level fix in the dbf header to stop that look for the cdx. Then my reindex routine is fine.
>
>__Stephen

Stephen, if you have to do this outside of the USE command, you can open the dbf with low level commands (FOPEN) and alter byte 28 to signify that the table has no associated cdx. Byte 28 is signifies several things, attached cdx is just one of them. From the VFP help under file structures:

0x01file has a structural .cdx
0x02file has a Memo field
0x04file is a database (.dbc)
Note that this byte can contain the sum of
any of the above values. For example, 0x03
indicates the table has a structural .cdx
and a Memo field.
Erik Moore
Clientelligence
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform