>On my form, I have a grid datasourced to a view. When I add a record to the view, even though I do an INSERT into the view, followed by a TableUpdate, followed by specifically calling the grid's REFRESH, which REQUERYs the view, the darn thing isn't showing the new record.
>
>If I move to another record in the master table (which controls the form), then back, the new record in the grid shows....
>
>any ideas?
The table backing the view is buffered as well as the view; if it's record-buffered, the table forces itself to TABLEUPDATE() every time it's record pointer is moved, so until the table is closed, the view will only show the record-to-last's changes, since the backing table's data is onlt SELECTed against without considering any uncommitted changes in the table's content. Either not buffering the table so changes made to the view are committed directly to the file, and not the file's buffer as is the case with double-buffering, or performing a TABLEUPDATE() against the table after the TABLEUPDATE() of the view but before the REFRESH invokes the View to REQUERY will fix it if this is the case.