>>>>>>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?

You may want to check this thread Grid - CursorAdapter Thread #1073232 Message #1073232