[resolved] How to update bridge table

[Anonymous]

Hi,
Mac OS El Capitan, TOS 6.1, Postgresql
How can i update a bridge table ?
update table
set colB = NewValue
where colA = value AND colB = OldValue;
Seems that this option can be found in Use field options.
How can i transmit those values for colB from tMap ??
Best regards,
Carlos

[Anonymous]

nobody for me ?
I want to transmit to the bdd output two different values for the same column to be able to make a set col = newvalue where col=oldvalue ?

[Anonymous · Accepted solution]

You will need to use database "Row" component. In this component you can write your own update statement and populate the parameters as you wish (using Java String concatenation). 

[Anonymous]

Thanks Richard.
Will test it asap.
Carlos