>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
>
There is no neseccity to put cursor in DE. Create cursor, exactly as you did and then link it to grid in Grid.Init event:
This.Recordsource="curBrowseOrders"
This.Refresh
Edward Pikman
Independent Consultant