Jan 18, 2007 AnyDAC is very flexible and transparent to the programmer at data updates. 12 parameters control all aspects of posting data updates to the DBMS.
AnyDAC can generate updating SQL commands automatically and use commands provided by programmer.
Generated SQL commands are optimized for target DBMS and takes into account all aspects of updated data. AnyDAC will automatically refresh fields, whose values may be modified by server side after update, like incremental / identity fields, modified by trigger fields, calculated fields (ROWID, time stamp, etc), etc. Command generator is aware Oracle RETURNING phrase, PL/SQL blocks, batch commands and other SQL dialect constructions.
Programmer can choose between pessimistic, optimistic or none locking (LockXXX) and update (UpdateXXX) modes.
AnyDAC supports extended cached updates mode. In the mode single updates journal stores synchronized updates from different datasets.
|
