| Since version 1.006 the DigaSQL.DLL can calculate consecutive identifiers for some columns when a new database entry is created, or an existing is modified. Typically an ID like "SN1234" is generated for a column like Registration. With the following parameters you can influence how these numbers are generated. For all values local settings are preferred.
Action:
- New entry
Mode REPLACE (default): New RN
Mode COMPLETE: New RN
- Copy complete Metadata from Original; RN exists in Source
Mode REPLACE (default): New RN
Mode COMPLETE: New RN
- Copy complete Metadata from Original; RN does not exist in Source
Mode REPLACE (default): New RN
Mode COMPLETE: New RN
- Copy an entry within the same table
Mode REPLACE (default): New RN
Mode COMPLETE: Old RN
- Copy an entry into a new table
Mode REPLACE (default): New RN
Mode COMPLETE: Old RN
- Simulated Overwrite (replacing an existing entry)
Mode REPLACE (default): New RN
Mode COMPLETE: New RN
- Move an entry between tables
Mode REPLACE (default): New RN
Mode COMPLETE: Old RN
- Modify Metadata
Mode REPLACE (default): Old RN
Mode COMPLETE: Old RN
- Add text media file
Mode REPLACE (default): Old RN
Mode COMPLETE: Old RN
- Add any media file
Mode REPLACE (default): Old RN
Mode COMPLETE: Old RN
- Create entry through automated processes
(e.g. DigAlign, Replication); target entry exists
Mode REPLACE (default): Old RN
Mode COMPLETE: Old RN
- Create entry through automated processes
(e.g. DigAlign, Replication); target entry does not exist;
Source contains RN
Mode REPLACE (default): New RN
Mode COMPLETE: Old RN
- Create entry through automated processes
(e.g. DigAlign, Replication); target entry does not exist;
Source does not contain RN
Mode REPLACE (default): New RN
Mode COMPLETE: New RN
|