Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
USE table without structural index
Message
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01459949
Message ID:
01460271
Views:
60
>>>Hi,
>>>
>>>Is there a way (a command or option) to USE a table and make VFP to ignore the fact that structural index file (table.cdx) does not exist? I know I can catch it with an TRY/CATCH error but my purpose is to open/use a table to check the structure of the table. And in some cases the structural index file is missing and I have to deal with it.
>>
>>Open the table low-level and write a zero in the 28th (or was it 29th) byte of the header, then fclose it. Then it will not ask for the structural index, because that byte is the indicator that the table has it.
>>
>>Another way is to open the table exclusive, catch the error, then open once more - Fox will then reset this byte by itself, so on second open it will not even look for the cdx.
>>
>>This is 2.x technique, but should work even today. Haven't had a case in years, so I can't really say it's been recently tested.
>
>Thank you for the suggestions.


Is there any way to open a table and NOT open the cdx?

TIA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform