BIG Progress 91.d Problem

[Dusty Lau]

BIG Progress 9.1d Problem

I have a BIG problem.
I have a customer that is running on software with a PROGRESS database backend.
The application is using a table that has a column named 'SYSDATE'.
'SYSDATE' is also a PROGRESS RESERVED WORD so the use of it as a column name was a wonderful idea on the software manufactures side.
So my problem is if I write an insert or update statement I get a syntax error.
I need really really really need to update that fields value or I'm in trouble.

Example:

UPDATE PUB.PartTran SET SYSDATE = SYSDATE() WHERE (PartNum = '123-123-123')

=== SQL Exception 1 ===
SQLState=42000
ErrorCode=-20003
[JDBC Progress Driver]:Syntax error (7587)

 

[KnutHandsome]

Disclaimer: I don't know SQL.

Try wrapping SYSDATE in quotes.

eg.

UPDATE PUB.PartTran SET "SYSDATE" = SYSDATE() WHERE (PartNum = '123-123-123')

or

UPDATE PUB.PartTran SET PUB.PartTran."SYSDATE" = SYSDATE() WHERE (PartNum = '123-123-123')

There are a couple of entries in the Progress Knowledgebase that suggest this for querying, so hopefully UPDATEs will follow similar workarounds.

Other than that, I wouldn't know.

 

[Dusty Lau]

IT WORKED!!!
THANKYOU!!!:blush: THANKYOU!!!:blush: THANKYOU!!!:blush:

I needed that really badly.
I have been beating my head over that for a few days now.
I tried a bunch of things similar to that not the double quotes.

HORRAYYY!!!!

 

[KnutHandsome]

IT WORKED!!!
THANKYOU!!!:blush: THANKYOU!!!:blush: THANKYOU!!!:blush:

HORRAYYY!!!!

Can I use this as my signature line? (Joke)

Kudos to the knowledge base again.