Thank you Mr. Egon.
put in "prefereprepared = true" properties TZConnection solved the problem.
The column set to BIT (1) field appeared with the data normally and could be edited without problems.
Search found 3 matches
- 10.11.2014, 00:56
- Forum: ZeosLib 7.1 stable Forum
- Topic: ZEOS with BIT(1) field in MySQL and Delphi
- Replies: 15
- Views: 4198
Re: ZEOS with BIT(1) field in MySQL and Delphi
Solved.
Thank you Mr. Egon.
put in "prefereprepared = true" properties TZConnection solved the problem.
The column set to BIT (1) field appeared with the data normally and could be edited without problems.
Thank you Mr. Egon.
put in "prefereprepared = true" properties TZConnection solved the problem.
The column set to BIT (1) field appeared with the data normally and could be edited without problems.
- 09.11.2014, 22:22
- Forum: ZeosLib 7.1 stable Forum
- Topic: ZEOS with BIT(1) field in MySQL and Delphi
- Replies: 15
- Views: 4198
Re: Does anyone managed to use BIT (1) field in Delphi and u
Hi, A little testcase would be nice. Note Zeos assumes TBooleanFields for enum('Y','N'); ========================================== Sorry .... I must have expressed myself badly. I have two tables tests. In a table defining the field as tinyint (1). In another table defining the field as bit (1). I...
- 09.11.2014, 21:49
- Forum: ZeosLib 7.1 stable Forum
- Topic: ZEOS with BIT(1) field in MySQL and Delphi
- Replies: 15
- Views: 4198
ZEOS with BIT(1) field in MySQL and Delphi
The ZEOS works very well with MYSQL database. I have not had a problem until I started doing tests with boolean fields. I have two tables in a Boolean fields are defined as TINYINT (1). Another as BIT (1). Using HEIDE or MYSQL front, I can see the columns and edits them normally without problems. Wh...