A form I am currently building is part of a Change Order system. To begin with, the application needs to access a table from our accounting system (written in FoxPro) to gather all current orders and display them to the user so that the user can select one.
Below is what I have attempted so far. I am attempting to SELECT INTO CURSOR in the Load event of the form. From there, my intentions were to display the data on a Grid in the form. PROBLEM: There is no cursor to put in the Data Environment of the form at design time. I'm not even sure if I'm going about this right. Would appreciate help. TIA, Chuck
SELECT * ;
FROM OrdrHdr ;
INTO CURSOR curBrowseOrders ;
WHERE SUBSTR(CstOrd,1,1) <> " " ;
ORDER BY CstOrd
Chuck Henry