Page 1 of 1

Insert or append to a database

PostPosted: Tue Feb 21, 2006 8:24 am
by ian
DataSlave will either insert new rows or update existing rows in a database. How does it know which to do? This is controlled by a primary key column. If you define the primary key then DataSlave can use this key to recognise an existing row and update the data rather than inserting a new row. You can define the primary key in a Read Object or in a Transform Object. Please see the User Guide for more information.

Note: You can not normally write data to the primary key in a database. If for example the primary key column in an Access database is an Autonumber column then the Access engine will create the entry as rows are added. To avoid attempting to write to the Autoonumber field, open the Transform Object properties, press the Edit button and remove the primary key. This does not removbe the column, but removes it from the DataSlave map so that no attempt is made to write data to it.