Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Lost programs, undeclared arrays, reports, and misc. q's
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00087807
Message ID:
00089426
Views:
37
>>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform