General information
Category:
Coding, syntax & commands
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.
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