>>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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only