Isn't it ORDER BY inventory.stocknum?
>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
JESS S. BANAGA
Project Leader - SDD division
...shifting from VFP to C#.Net
CHARISMA simply means: "Be more concerned about making others feel good about themselves than you are in making them feel good about you."