Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Syntax to break a dbf from it's cdx.
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00317076
Message ID:
00317121
Vues:
16
>>>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform