PROPERTY TABLE tablename 'REFRESH' Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected] From: [email protected] [mailto:[email protected]] On Behalf Of Lawrence Lustig Sent: Thursday, June 21, 2012 9:47 AM To: RBASE-L Mailing List Subject: [RBASE-L] - How to force refresh of DBGrid drop down values
I have a DBGrid containing a drop-down column specified using the Expression tab of the Column properties. I'm using a WHERE clause on the Expression tab to limit the user's choices. The WHERE clause is of the form "WHERE MyIDColumn = .fRCW_MyIDValue". The variable fRCW_MyIDValue is set inside the form, after it starts. The problem is that the list of values in the drop down seems to be loaded at form start-up and does not change when I change the value in fRCW_MyIDValue. If this variable does not exist at the time I start the form, no values are available in the drop down. Is there a PROPERTY command to force the grid to refresh the lookup values either directly or by tricking the grid somehow? -- Larry
