TMyTable - TINIINT(1) not working with a filter

T.Juentgen · Post by **T.Juentgen** » Thu 03 Feb 2005 16:16

Hello I have a problem with
MySQL Server 4.1.9
MyDAC 3.5
Datatype is TINIINT(1)

I'm using a TMyTable component and use a filter n_tiniint = 1
I'm getting no record. If I use a TMyQuery with the statement
SELECT * FROM t_table WHERE n_tiniint = 1
I get records.

Where is the problem?

Thanks for your help

Guest · Post by **Guest** » Thu 03 Feb 2005 16:24

Sorry I found a topic regarding the problem
-------------------------
Since MyDAC 3.10.1.7 TinyInt(1) fields are represented as TBooleanField. To solve problems declare these fields as TinyInt(4) or set TCustomMyDataSet.Options.EnableBoolean := False

> Also, the connection process now takes several seconds instead of the old 1
> second or so. Why so slow now?

Does this time depends on MyConnection.Options.Direct property?

Ikar · Post by **Ikar** » Fri 04 Feb 2005 08:58

We haven't noticed it.

> Does this time depends on MyConnection.Options.Direct property?

Please check. It is too important for diagnostics of the problem.