Page 1 of 1
TMyStoredProc with bit field shows up as TLargeintField
Posted: Tue 15 Apr 2008 07:35
by p_schalk
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?
Posted: Tue 15 Apr 2008 09:09
by Dimon
This depends on the query.
You should read about TCustomMyConnectionOptions.OptimizedBigInt property added for mapping LargeInt fields to Integer fields.
Posted: Tue 15 Apr 2008 09:30
by p_schalk
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?
Posted: Wed 16 Apr 2008 10:42
by Dimon
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.