Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Update statement in Progress gets syntax 7587 error

Status
Not open for further replies.

lmwills

IS-IT--Management
Oct 10, 2001
8
CA
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.
 
The correct is:

UPDATE PUB.RFERecord
SET PUB.RFERecord.Screens-ID = '014'
WHERE PUB.RFERecord.System-ID = 'BBD'

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top