Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Re-binding RecordSource to grid, and ControlSources to C
Message
 
To
24/03/2004 20:51:31
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00889474
Message ID:
00889502
Views:
22
When the form loads, the grid's controlsource is an empty curDrawings cursor?

The curDrawings cursor is then appended to and zapped based on a combo box interactive change?


>I have a VFP 8.0 form with a Grid on it that derives it's data from a dynamic Cursor, that is re-created based on value from ComboBox selection, that is used in SQL query.
>
>I have been having problems figuring out how to refresh the Grid with new data from this Cursor, each time the Cursor is re-generated.
>
>I have the following code following my CURSOR statement.
>
>Thisform.grdDrawings.RecordSource = "curDrawings"
>Thisform.grdDrawings.colDwgNum.ControlSource = "curDrawings.dh_dwgnum"
>Thisform.grdDrawings.colRev.ControlSource = "curDrawings.dh_rev"
>....
>....
>
>I'm getting an error message: Member colDwgNum unknown. When the ControlSource line executes. Regardless, the grid appears to refresh with new Cursor data after I dismiss Error dialog.
>
>How do I handle a clean, error-free Refresh of the Cursor-sourced grid?
>
>Thanks,
>
>Dbk
Imagination is more important than knowledge
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform