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