<< Click to Display Table of Contents >> Navigation:  10. FAQ > 10.10. Working with Databases > 10.10.4. Securely adding rows to a database table > 10.10.4.1. Incremental Table Upload

 

The procedure given in this section guarantees to have no duplicated or lost rows when uploading rows inside a database. This procedure also allows for “Incremental Upload” where we only upload inside the database the new rows that were not there yet.

 

 
To add a a few rows (available inside a file named <source.gel_anatella>) inside the “final” Table T, we will run the following steps:
 
 

1.Run a “SELECT MAX(<primary_key>) FROM <Table T>” and save the result inside a “Global Parameter” named “MaxPK”: This is done this way:

 

 

2.Run the following:
 
 

 

3.(Optional:) Delete the (local) file <source.gel_anatella>: