when I put the command (while "Paginate results" is checked)
update mytable set id = 6 -- just a simple table, 2 columns are enough, e.g. id as integer and name as varchar
into the SQL box, an error is generated saying:
ERROR: syntax error at or near "set"
LINE 1: SELECT COUNT(*) AS total FROM (update mytable set dn_id = ...
SELECT COUNT(*) AS total FROM (update mytable set dn_id = 6) AS sub
I can put the command above into an external sql and open by Browse.., that will do.
If I do in SQL box while "Paginate results" is un-checked, it will do also.
Similar results for insert-command.
Thanks for review.