One more thing Jimmy - I recommend you add a NOFILTER clause to the INTO CURSOR tempcursor. If you should use a fully optimized query, VFP uses a filter instead of creating a tempory dbf. DBF(Cursorname) will point back to the original table and the USE AGAIN will show all records of the original table. In your example, the ORDER BY prevents the query from using a filter, but it's a good idea to use NOFILTER any time you use the USE AGAIN code on a cursor created with an SQL SELECT.
>You can only run a REQUERY() on a view or a combobox that has a SQL for the source.
>
>>it works but I can't run a REQUERY() on it. It give an error stating "function not allowed on native tables". Is there something else I can run on it?
>>
>>>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?
David.