TMyTable - TINIINT(1) not working with a filter

TMyTable - TINIINT(1) not working with a filter

Postby 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
T.Juentgen
 

Postby 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?
Guest
 

Postby 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.
Ikar
 
Posts: 1693
Joined: Thu 28 Oct 2004 13:56


Return to MySQL Data Access Components