I’m using an “Add a new row to another table…” action to create or update rows
when the key in ‘table to add’ doesn’t exist the action add a new row with the columns value that are in the list ‘Set these columns’ to insert: this is good
when the key exist the action add a new row make an update with the columns value to update this is good, but the others columns that are not in the list ‘Set these columns’ are set to null(). normally has they are not in the list of column they should not be modified.
ImportPerson= table where I’ve got person to import
Person = table with all the person
PersonID = key
my Action is Add new row to another from ImportPerson to Person
Set these columns:
PersonID = ImportPerson.PersonID
LastName = ImportPerson.LastName
FirstName = ImportPerson.FirstName
if the ImportPerson.PersonID doesn’t exist in Person I want to add this person in my data base
This is ok the insert is done with the good values
if the ImportPerson.PersonID exist in Person I want to update this person in my data base with the values that are in ImportPerson but not to change ResponsibleUser, NextDateToCheck
The update is done, but ResponsibleUser, NextDateToCheck are set to null !!!
if not a bug how can I do a update on some columns of my table and not on all the column of the table?