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.