Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Load Event, Creating Cursor in
Message
From
01/07/1999 16:32:46
 
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00236691
Message ID:
00236695
Views:
9
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform