This is my statement and it hates it:
UPDATE PUB.RFERecord
SET PUB.RFERecord."Screens-ID" = '014'
WHERE PUB.RFERecord."System-ID" = 'BBD'
=== SQL Exception 1 ===
SQLState=42000
ErrorCode=-20003
[JDBC Progress Driver]:Syntax error (7587)
I did an insert statement to the same table and it worked fine.
This is the first time I am working with Progress- I am using the SQL Explorer to make my changes.
UPDATE PUB.RFERecord
SET PUB.RFERecord."Screens-ID" = '014'
WHERE PUB.RFERecord."System-ID" = 'BBD'
=== SQL Exception 1 ===
SQLState=42000
ErrorCode=-20003
[JDBC Progress Driver]:Syntax error (7587)
I did an insert statement to the same table and it worked fine.
This is the first time I am working with Progress- I am using the SQL Explorer to make my changes.