TMyStoredProc with bit field shows up as TLargeintField

p_schalk · Post by **p_schalk** » Tue 15 Apr 2008 07:35

I just installed the latest version 5.20.1.15 of MyDAC, but I still have the problem that the StoredProc with a bit field in the select is interpreted as a TLargeintField and not as a TBooleanField.

Is this a bug?

Dimon · Post by **Dimon** » Tue 15 Apr 2008 09:09

This depends on the query.
You should read about TCustomMyConnectionOptions.OptimizedBigInt property added for mapping LargeInt fields to Integer fields.

p_schalk · Post by **p_schalk** » Tue 15 Apr 2008 09:30

I'm not sure what you mean.
I have a table with one of the fields defined as bit.
In my stored proc I do a select * from the table, so the result is a dataset.
When I add the fields in Delphi, I get a fieldtype LargeInt.

Do you mean I need to enable OptimizedBigInt?

Dimon · Post by **Dimon** » Wed 16 Apr 2008 10:42

Most of MySQL APIs don't provide ability to distinguish BIT(1) and BIT(>1). So, all BIT fields, including BIT(1), are represented as TLargeintField.