Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Automatically detect if indexes are present and delete t
Message
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00570924
Message ID:
00570964
Views:
17
This message has been marked as the solution to the initial question of the thread.
Here's a corrected version
lcTable = "mytable"
lcPath = "C:\mypath\"

lnFH = FOPEN(lcPath + lcTable + ".dbf", 12)

* Check if there is structural CDX
= FSEEK(lnFH,28)

lnByte28 = ASC(FREAD(lnFH,1))
lnCDXStr = BITAND(lnByte28, 1)

IF lnCDXStr = 1    && there is CDX
	IF FILE(lcPath + lcTable + ".cdx")
		ERASE (lcPath + lcTable + ".cdx")
	ENDIF
        = FSEEK(lnFH,28)
        = FWRITE(lnFH, Chr( BITAND(lnByte28, 0xFE) ))
ENDIF

= FCLOSE(lnFH)
Sorry, I got distracted by something and sent message before it was ready.
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform