Error in UPDATE

[BredrickSa]

When I perform an UPDATE, an error is always returned, for example:
UPDATE table SET field_a = 'S' WHERE field_b = 'A03';
ERROR: operation not supported. [SQL state = 1007]

I don't know if all DML routines are already implemented, if they are already, I believe I'm doing something wrong.

I am using Workbench / J for manipulation between databases. Queries are returning perfectly.

• OS: Windows 10
• Java: 8 (build 1.8.0_191-b12)
• App: SQL Workbench/J (Build 125 - 2019-05-08 21:36)
• JDBC: v1.4.1

[leonhad]

Hi,

There is nothing wrong with your code. I don't write INSERT, DELETE or UPDATE statements yet.

By now, I am working on a better SQL Parser. The next step will be these statements.

Because of the complexity of these operations, I will need a couple of months to do it or a little more.

[BredrickSa]

Hi,

I understand you. I'll look at the logic in the source code, maybe I can help with this project. ;)