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