In the Load Event of a form, I am creating a CURSOR from which to validate user input.
In the Debugging process, I have noticed that I cannot create an index tag on the CURSOR without SET DELETED ON.
Without SET DELETED ON, when the code gets down to the INDEX ON command, it trys to index on the E:\ADI\EBAAData\OrdrHdr file (the result is that I get an error message stating that file is read-only, which is good because altering that file's CDX would be a big no, no), even though I specifically SELECT curOrdrHdr just before the INDEX ON command.
Would appreciate explanations / suggestions. Here's the code...
SELECT ;
Invoice, ;
ShpNam ;
FROM E:\ADI\EBAAData\OrdrHdr ;
INTO CURSOR curOrdrHdr ;
ORDER BY Invoice
SELECT curOrdrHdr
INDEX ON Invoice TAG Invoice
USE IN SELECT( "OrdrHdr" )
Chuck Henry