Hi,
I just found that updating with DBOutputTable takes :
‘update table set field = ? where otherfield = ?’
in sqlQuery and
‘fieldmeta1;fieldmeta2’
in cloverFieldMap.
So far so good. But the doc for the component says :
update mytable set f1 = $field1,…,fn=$fieldn
- where f1,…,fn are database fields and field1,…,fieldn are input record fields
I couldn’t get this syntax to work.
SO, am I missong something, or should the doc be corrected ?
Franck