Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Passthrough & Control Sources
Message
From
24/09/2001 11:55:15
 
 
To
23/09/2001 23:25:40
Chuck Berry
Copper State Bolt & Nut Co.
Phoenix, Arizona, United States
General information
Forum:
Visual FoxPro
Category:
The Mere Mortals Framework
Miscellaneous
Thread ID:
00559838
Message ID:
00560040
Views:
22
You either have to do the passthru in the Load of the form, so the cursor will be there when the grid is instantiated, or you have to set the control source to the grid, in code after doing the pass thru... like...

ThisForm.Grid.RecordSource = ''
ThisForm.GetData()
ThisForm.Grid.RecordSource = 'MyCursor'

>Hi Everyone,
>
>What is the procedure to populate a Grid using SQL Passthrough? I keep getting invalid control source errors when opening up my find form. When I suspend the find form, I am receiving the result set, it's just that the grid is not getting populated.
>
>My getsqlstring method keeps going away automagically, does this happen to anyone?
>
>Normally I would do a search but it's still not working :(
>
>Thanks,
>
>Chuck
Previous
Reply
Map
View

Click here to load this message in the networking platform