Should, but your ORDER BY is wrong. Remove the tempcursor. reference. It should be ORDER BY STOCKNUM

>>The error means that TEMPCURSOR does not exist. Therefore, you can not USE it AGAIN.
>>
>
>But judging from this:
>
>SELECT inventory.stocknum AS stocknum;
>FROM Tomparco!inventory AS inv_this_trans;
>INTO CURSOR tempcursor;
>WHERE inv_this_trans.trans_id = trans_num; &&trans_num is a variable
>ORDER BY tempcursor.stocknum
>
>Shouldn't it exist?