>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

Sorry, blah2.fld5 should be blah2.fld4