Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Refreshing a grid that uses a SQL statement
Message
De
08/08/2001 18:35:25
Larry Huisingh
Lockheed Martin Information Technology
Richland, Washington, États-Unis
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Divers
Thread ID:
00541558
Message ID:
00541603
Vues:
9
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform