Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
INDEX ON Problem with SQL CURSOR
Message
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
INDEX ON Problem with SQL CURSOR
Divers
Thread ID:
00380216
Message ID:
00380216
Vues:
63
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...
*prjChgOrder.frmNewChgSD.Load

* To create CURSOR for Invoice number validation & to provide ShpNam data...

SELECT ;
	Invoice, ;
	ShpNam ;
 FROM E:\ADI\EBAAData\OrdrHdr ;
 INTO CURSOR curOrdrHdr ;
 ORDER BY Invoice

* Furnish index to accomodate SEEK programmed into form.
SELECT curOrdrHdr
INDEX ON Invoice TAG Invoice

USE IN SELECT( "OrdrHdr" ) && Clean up from above SQL SELECT
Chuck Henry
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform