|
By default ("Append Data" mode), the program will add new
records to the selected table. There are three other modes:
- In the "Replace mode" the program removes all data rows
before adding new records. An alternative to this mode for a
database with a complex set of relationships is using the Clear Rule.
- The third case called the "Update Mode" is the most
complicated one. A table must have a Primary Key (PK) in order to
use this mode. If the table has no PK, you must manually select a
field for searching records to be updated (use the "..." button
near the mode box to select a column). The program goes through
records one by one taking into account the where clause specified
for this mode and updates those fields whose fill mode is not
Ignore.
- The "Scramble" mode (does not supported by Standard version) uses two tables of the same
or different databases. The program takes the contents of the first
table (considering the value of the WHERE clause) and gets data
rows from it sequentially. The values of columns for which Ignore
fill method was used are placed in the target table as is. All
other values are replaced with values generated according to the
used fill methods. In this case, the requirements for presence of
Primary Key or its manual specification in the source table
coincide with Update Mode. If the target table already exists, it
will be deleted without warning; after that the program will create
a target table identical to the source table.
|