>>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"