>>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
Before the replace the field in the table you need to Seek() or Locate the correct record in Blah2:
In the Double click event write:
SELECT Blah2
LOCATE FOR Id = tmpRoster.ID
REPLACE fld5 WITH .F. IN Blah2
That requires that ID is a unique field and that you add this key in the select statement into tempRoster. You also need to make sure that tmpRoster is not buffered.
Christian Isberner
Software Consultant