[Stackoverflow] [Progress OpenEdge ABL] Invalid number string (7498) JDBC Request

[Joe Doe]

I'm converting this progress statement into SQL.

for each usr_mstr where usr_userid matches "PRF52" exclusive-lock:
assign usr_force_change = no.
end.


This is what I currently have.

UPDATE PUB.usr_mstr SET usr_force_change = 'false' WHERE usr_userid = 'PRF52'


The error that I am receiving is '[DataDirect][OpenEdge JDBC Driver][OpenEdge] Invalid number string (7498)'.

A select statement for this field is working and returns the following.

SELECT usr_force_change FROM PUB.usr_mstr WHERE usr_userid = 'PRF52'


usr_force_change
false

Continue reading...