General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Thanks, Drew. I'll give it a try.
JD
>Hi Jimmy,
>
>I'm not sure if this is related (it could be), but your ORDER BY clause should either be
>
>ORDER BY inventory.stocknum
>
>or
>
>ORDER BY stocknum
>
>or
>
>ORDER BY 1
>
>It could have something to do with the cursor not existing yet.
>
>Cheers,
>
>Andrew
>
>
>
>>If I use the following code without the IF...ENDIF statement, everything works fine. Why would the IF...ENDIF cause the error Column 'stocknum' not found?
>>
>>IF ! USED('inv_this_trans')
>> SELECT inventory.stocknum, ;
>> LEFT(SUBSTR(inventory.p_descript,1,AT("$",inventory.p_descript,2)+8),50) AS memotxt, ;
>> inventory.trans_id ;
>> FROM Tomparco!inventory AS inv_this_trans ;
>> INTO CURSOR tempcursor ;
>> ORDER BY tempcursor.stocknum
>>
>> USE DBF("tempcursor") IN 0 AGAIN NODATA ALIAS inv_this_trans
>> USE IN tempcursor
>> ZAP IN inv_this_trans
>>ELSE
>> REQUERY('inv_this_trans')
>>ENDIF
>>
>>Thanks
>>JD
Previous
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