Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Lost programs, undeclared arrays, reports, and misc. q's
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00087807
Message ID:
00089426
Vues:
38
>>Ed, I've learned through hard experience that NOFILTER makes a 'real' cursor (instead of a filtered copy of the table) but does NOT always write the cursor to disk.
>>
>>Michelle, I think this may indeed be your problem. Possibly you could check your code and see how you are making and calling the indexes. Remember that your cursor (SELECT .... into MyCursor) isn't 'MyCursor' on the disk, but '0239847.tmp' or something similar. You're using an alias. Be sure your index name is the same as the cursor.
>
>-------------------------------------------------------
>
>Here's the actual code:
>
>create cursor inv (invnum N(8), lastdate D(8), company C(45), address C(30), city C(20), state C(2), zip N(5), zip4 N(4), phone C(13), client_num C(11),;
>cltname C(40), bname C(40), baddress C(30), bcity C(20), bstate C(2),;
>bzip N(5), bzip4 N(4), reccom_by C(8), item N(3), date D(8), time C(5),;
>pick_up C(20), drop_off C(20), amount N(8,2), prev_balnc N(9,2),;
>cust_curr N(8,2), cust_1_30 N(8,2), cust_30_60 N(8,2), cust_60_90 N(8,2),;
>cust_ovr90 N(8,2), cust_total N(9,2), selected L(1), copay N(5,4),;
>copay_tot N(5,4), orig_tot N(5,4))
>
>select inv
>index on reccom_by+client_num tag PAYNUM
>
>Later on, the code says:
>
>select inv
>set order to PAYNUM
>
>At this point, the computer logs an error that it can't find the variable "PAYNUM". At least on the one computer. On my computer it uses the index just fine.
>
>So you want me to change "paynum" to "inv" so the names are the same?
>
>I'm not doing a "select into". I just make the cursor and then I append to it as I gather information from two other tables.
>
>Thanks,

Michelle, try "Set order to TAG paynum"
Barbara Paltiel, Paltiel Inc.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform