Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#436 fail to insert, update via sql box

5.1
open
nobody
General (123)
5
2013-05-03
2013-05-03
woodz
No

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:

SQL error:

ERROR: syntax error at or near "set"
LINE 1: SELECT COUNT(*) AS total FROM (update mytable set dn_id = ...
^

In statement:
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.
woodz

Discussion

  • woodz
    woodz
    2013-05-03

    sorry did a mistake, you need to replace dn_id by id in sql error report