Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Refreshing a grid that uses a SQL statement
Message
From
08/08/2001 18:35:25
Larry Huisingh
Lockheed Martin Information Technology
Richland, Washington, United States
 
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00541558
Message ID:
00541603
Views:
14
I put this code in the page's Refresh() method.
this.grdAccSetSensors.Refresh()
dodefault()
but it made no difference. Anyone have any ideas?

>Call Refresh() method of the grid after you moved to the next record.
>
>>I have a multi-page form and one of the pages has a grid on it that I want to populate based on a SQL statement. I have set the RecordSourceType to "4-SQL statement" and I have set the RecordSource to the SQL statement itself. When I run the form I can see the grid with the correct values for the first record I am viewing with my form but when I move to another record the grid doesn't update. Does a grid that has a SQL statement for its RecordSource only run the query once? What's the best way to make the SQL statement be executed each time I navigate to another record? The SQL statement I am using is as follows (formatting added while writing this message):
>>
>>
>>select asetdetl.sensor_id, sensors.desc
>>  from asetdetl, sensors
>>  WHERE ASetDetl.sensor_id = sensors.id AND
>>  ASetDetl.acc_set_id = asetmast.acc_set_id
>>  into cursor setmembers
>>
>>
>>The table asetmast is the master table that I want to navigate and have the query run each time I go to another record.
Larry Huisingh
Lockheed Martin Information Technology
Richland WA USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform