[stackoverflow] [progress Openedge Abl] Select Cast(0 As Bit) In Progress Returns Error...

[Brett Ryan]

If I were to execute the following statement:

select cast(0 as bit) from customer


I get the error:

[DataDirect][OpenEdge JDBC Driver][OpenEdge] Inconsistent types (7481)


However, if I were to instead replace the integer literal with a field name such as:

select cast(SomeIntField as bit) from customer


where SomeIntField is an integer field storing 0 or 1 the query executes correctly.

I have noted progress article #56514 but can not contribute an update to inform about accessing a db field.

Continue reading...