Give this a try....


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


USE DBF('tempcursor') AGAIN IN 0 ALIAS inv_this_trans
USE IN tempcursor

Now you can make changes to inv_this_trans as you would a free table (the cursor is actually a table in your TEMP directory)

when you close inv_this_trans, the file is automatically destoyed for you.