>>I have a grid based on a view.
>>When the user click on the new command button, the system display a modal form for him to enter the information.
>>After the modal form is closed, a INSERT-SQL is done in the buffered table, a Requery() is perfomed on the view and the grid is refreshed.
>>My problem is that the grid doesn't show the new record until the new record is commited to the table.
>>I want the grid to show all records, buffered or not.
>>How can I do that?
>
>You can APPEND new record to view only without Insert-SQL to underlying table. This case (I assume you use Table buffering) you will see non-commited record in grid, although it's not in table yet.

I can't append the view, because:
A) The view don't have all the fields of the original table
B) The view is based on joined tables and only one need to be updated