>>>>>Can someone help me with the correct syntax for this sequence for a grid in a custom container?
>>>It would be much better to not use filter at all.
>>
>>Thanks Naomi -
>>You are probably right but if I SELECT into a cursor then I have to figure out how to get a record update back into the source table.
>
>I usually have a separate cursor for the grid (I may create it with create cursor command in form's load). When I want to change filtering, I select into new temp cursor, zaip in the original and append into it. Then I close the temp. It usually happens very quickly and not visible for the user.

I can handle running the grid with a cursor OK. But if a data item is edited, how do you put the new value back into the original table?