We have a need to select a few records out of a SQL table, list them in a grid, and then modify them. If we just use a remote view as the Grid.RecordSource, the results are displayed but as soon as a record is modified and the record pointer is moved, the SQL table cannot be queried, i.e.; it's locked until the results are updated. We also tried to use an offline view, but that needs to be opened exclusive and no one else can use the view.

We have Optimistic Row Buffereing set in both situations. We want to make any changes and then either batch update or revert.

Any suggestions?

Thanks

Tim