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