ODBC querey against a logical database field

[Boomn4x4]

I'm trying to do a data base query through ODBC on a logical database field, but cannot figure out how to do it..

I've tried "...where field = y, field = true, field = yes, field = 1"

none of them work.

For the interm, I've changed the field type to be integer and tested against 1 or 0, which works, but this isn't the way I should be doing it.

Thank you.

 

[Stefan]

field = 0 and field = 1 work via JDBC (OpenEdge Architect 10.2B04)

SELECT "adm-nr", "cost-center"
FROM pub.ccent WHERE block = 1

The above also works fine with MS Query which uses ODBC