Updating Data with the RDO RemoteData Control

RDO RemoteData Control data can be either read-only or modifiable. To create an application that modifies data using RDO RemoteData Control, do the following:

1. Set the RDO RemoteData Control CursorDriver property.
   • Server Side cursors store returned data on the server.
     
     
   • ODBC Client Side cursors store data in the client's local storage.
     
     
   • Client Batch Side cursors use a cursor library designed to deal with concurrency issues.
     
     
   • No Cursor option is used when an action query is performed, and thus no cursor is necessary.
2. Set the RDO RemoteData Control LockType property. The optimistic concurrency based on resultset option is recommended.
   • Read-only concurrency should not be used if you want data to be modifiable.
     
     
   • Pessimistic concurrency locks data during update so that other users will not be in danger of committing incompatible data changes.
     
     
   • Optimistic concurrency does not lock data, but if during commit, it detects that another client has posted an incompatible state, the RDO RemoteData Control throws an error.
3. Set the RDO RemoteData Control ResultsetType property. Make sure the ODBC driver supports the chosen options.
   • When Create Static Cursor is chosen, the changes are not detected until the cursor is closed and reopened.
     
     
   • When Create Keyset Cursor is chosen, the cursor allows inserts, updates, and deletes, at will, within the keyset cursor itself.
4. Set the data-bound control as needed to allow updatability. Note that some controls do not allow updating.

See the documentation on the RDO RemoteData Control for information on how to use these objects; see Getting Help on Controls.

Back to Using RDO Databinding in Visual C++.