HelloI need to delete a value from a colum which type is datetimeI'm doing it Inside a worflow (update component) because I'm updating other fieldsI tried to use the NULL value in my Update compoennt, like I did to erase String value but it does not work.I have an error message saying that NULL (typ...

Hi Jean-SergeThanks for your inputs, they helped me solved my problème.My 2 mistakes were the following:- updating a value with the '' string (empty string) does not work (the value is not erased)- when using the NULL value, you canot just enter NULL in the list of field to be updated. You need to c...

I was looking for a non-sql solution, to keep the workflow easy to understand for people with less database skills.Or does this mean it is not possible delete some values using the Update data component ?

Yes, I'm doing the "Update" operation because I need to keep the record and just delete some of its value

HiI need to do something that should be easy: deleting information from the table (I'm deleting adress information that is no longer accurate).However, I can't seem to do it.I'm using a data update component and for each field that need to be deleted, I'm setting the source to ''. At runtime, this e...

Thanks for your help, it works fine !

HelloI'm stuck with something that should have been easy to do: I need to compare 2 values and do different things depending on the result.The 2 values type are string.My first idea was to use a simple "equal" condition in the filtering window.But checking the result, I realised that 2 empty field w...