Hello,
I am trying to update a postgres table from a ReTool table but it is not working because ReTool's string value has double-quotes around it instead of single quotes which are required for postgres. Please see below.
Is there a way to replace the double-quotes for single quotes? or any other thoughts?
Thanks
The following query works
update table1
set string_var = 'Y'
where id = {{table1.selectedRow.id}}
But the following query does NOT work because {{table1.selectedRow.string_var}} = "Y"
update table1
set string_var = {{table1.selectedRow.string_var}}
where id = {{table1.selectedRow.id}}