Page 1 of 1

TMyTable - TINIINT(1) not working with a filter

Posted: Thu 03 Feb 2005 16:16
by T.Juentgen
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

Posted: Thu 03 Feb 2005 16:24
by Guest
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?

Posted: Fri 04 Feb 2005 08:58
by Ikar
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.