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