General information
Category:
Coding, syntax & commands
Title:
Refresh data in a grid
Hello All!
I'm having difficulties with the following;
I've a grid populated with data from a table which I create using (without qoutes)
"Select fld1, fld2, fld3, blah2.fld4
FROM blah1, blah2
WHERE blah1.id = blah2.id
AND blah2.fld5 = .T.
INTO TABLE tmpRoster"
.grdRoster.RecordSource = "tmpRoster"
.grdRoster.Refresh
Now the above works fine. However, I've some code based upon a Dbl Click which upon saving, change blah2.fld5 to .F. When I rerun the SELECT statement, it doesn't reflect the change (i.e. in other words the record still show, but the data has been properly updated).
Another thing, when ran in the VFP environment, it works. Within the application, it doesn't.
It's driving me crazy as I thought it would be the simplest way to accomplish this task. What am I missing/not seeing? (I didn't add any other code but focused on what gathers the data)
TIA,
Vernon
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only