I tried the AddCtrlAt / StartInsert all seem to run well :
* when invoking StartInsert a new line is appending at the end of my SqlArray
* Controls linked to the Array with AddCtrlAt seem to "insert" the new values in the new array line ...
...but, the key column is the only one to remain empty.
For now, Reading and Updating from the gui to the DataBase is OK but creating a new line in the DB is quite problematic...
I tried to alter the definition of the array with AppendingAuto and then AutoInsertId ( I thought it could have get a primary key for the new row) but I got a Sql Error (two ID insertion attempt).
Do you have an idea to get this SQL insertion running ?
Unfortunately, this depends on DB choosen. For PGSQL or Oracle, I recommend using sequence and use it with InsertValue.