BorlandTalk.com

Todd Grigsby · Guest

Several databases I've run across do not support boolean fields. Is there a way
to tell a TBoolean to use an integer field as though it were an integer field or
to tell a dataset to treat an integer as a Boolean?

CONFIGURATION:
MySQL 4.1.3b beta
MyODBC 3.51

I've built several tables with fields that are defined as boolean. In Delphi, I
have a dataset in which I've autopopulated the field list, and those fields are
of type TBooleanField. But when I open the dataset, the field types being
returned by the MyODBC driver are of type integer, so I get a datatype conflict.

MY QUESTION: Does anyone know of either 1) some way to tell TBooleanFields to
treat a smallint as a boolean, or 2) tell MyODBC to describe the field as a
boolean rather than as a smallint?

Thanks in advance,

Todd