Solved. Use
update tbl set (col1, col2, ...) = ROW(val1, val2, ...) where id=xx
Thank's to Laurenz Albe in the german mailinglist.
Am 03.02.21 um 11:31 schrieb Ulrich Goebel:
Hi,
in a Python Script I build an UPDATE using the syntax:
update tbl set (col1, col2, ...) = (val1, val2, ...) wher
Hi,
in a Python Script I build an UPDATE using the syntax:
update tbl set (col1, col2, ...) = (val1, val2, ...) where id = xx
That works as long in the two lists are more then one column and values.
If I have just one column and value, I get an error message:
=
