We use VFP3.0B with CodeBook, Win95, Win NT on the server and Sybase as the backend database.
We use VFP in the RowBuffering mode and it works really well for most of our business objects since CodeBook works with one record at a time. However we have a problem with grids.
We have some cases where we want to display several related records in a grid. We want to make changes to the records as a set and update the database with the changes of all records as a set. Here come the questions:
1. Is it possible to save more than one record at a time while maintaining RowBuffering mode? If so, how?
2. We do not want to FORCE the update to the table since we may overwrite an update that took place since we retrieved the records for update. We do not want to switch to TableBuffering mode for all views. Is it possible for us to switch to TableBuffering for this view only? How?
Your help is much appreciated.
Mario