General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Column 'name' Not Found
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
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