ADO & SQL 7.0 Bit Field

[Robert]

When retrieving a bit field from SQL 7, represented in SQL 7 by a 1 or a 0,
ADO transforms the field into adboolean resulting in the words "true" or
"false" when written out. It seems unnecessarily clumsy to have to manually
convert that to a 1 or a 0 every time this data is retrieved, for my objects
are placing those values in an XML string that mirrors the database. Do
you have any alternative?

[Bill Vaughn]

Nope, I'd have to play with it to see...

b
"Robert" <needguaranteeof@emailnotusedfor.soliciting> wrote:
>
>When retrieving a bit field from SQL 7, represented in SQL 7 by a 1 or a
0,
>ADO transforms the field into adboolean resulting in the words "true" or
>"false" when written out. It seems unnecessarily clumsy to have to manually
>convert that to a 1 or a 0 every time this data is retrieved, for my objects
>are placing those values in an XML string that mirrors the database. Do
>you have any alternative?