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?