General information
Category:
Coding, syntax & commands
I'm getting an error "alias not found" on this line:
USE DBF('tempcursor') AGAIN IN 0 ALIAS inv_this_trans
I tried again just using:
USE DBF('tempcursor') &&AGAIN IN 0 ALIAS inv_this_trans
so I suspect the alias the error is referring to is tempcursor
anyone know why?
Thanks
JD
>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