DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

number(1) as boolean

421258May 13 2004 — edited May 17 2004

I'm converting a db from MS SQL to Oracle 9. Some of the tables have bit fields used as booleans that got mapped to numeric(1). Everything seemed ok until I tried to run the application. The application is written in VB6 and the code is checking these numeric(1) fields in an if statement comparing the value of the column to True. When I examine the value of the column, it has a value of either 0 or 1 and the comparison to True always returns false. Is there a way that I can tell the ole provider to interrupt numeric(1) columns as boolean so I don't have to change the code. Thanks for any suggestions.

Eric Lyons

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 14 2004

Added on May 13 2004

#oracle-provider-for-ole-db, #windows-and-net

1 comment

740 views