General information
Category:
Coding, syntax & commands
>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,
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only