Update Logical field through Merant 3.60

[job419]

Hopefully this is the correct forum. First off, I'm not very familiar with Progress. I usually use SQL Server, but I have a client requirement to connect to Progress from a vb.net application. So far I've been having good luck with it but ran into a snag.

I'm having trouble updating a logical (bit) field to True through the "Merant 3.60 32-BIT PROGRESS" ODBC driver. I've tried multiple syntax:

logifld = '1'
logifld = 1
logifld = 'yes'
logifld = yes
logifld = 'true'
logifld = true

But I can get to work. Can someone shed some light on this for me?

My full sql statment is:

UPDATE co SET LOGIFLD = '1' WHERE co-num = '12345'

Thanks for your help in advance!

EDIT: I found that if I use "logifld = {L 0}", it sets the value, but {L 1} is not working. How do I set it to true?

 

[job419]

Someone gave me the answer to this on experts-exchange. Had to let the ODBC driver do the conversion.

UPDATE co SET LOGIFLD = { fn CONVERT ( '1' , SQL_BIT ) }

 

[tamhas]

It has been a while, but my memory is that 1 and 0 work just fine on their own without and conversion and quotes. I'm pretty sure that is true on read, but I think write too.