There might be other places when something like this needs to be done for FPC/Lazarus.
The other day I again saw a lot of ?? field value returns for some simple string fields (not calculated fields, just normal db fields) on Windows (did not check on Linux).
Search found 5 matches
- 08.06.2011, 18:52
- Forum: User Patches
- Topic: [patch_done] Fix datetime to string Lazarus program MySql
- Replies: 4
- Views: 2632
- 22.05.2011, 00:40
- Forum: ZeosLib 7.0 Beta Forum
- Topic: 7.0 SVN MySQL calculated field content is returned as ??
- Replies: 4
- Views: 753
- 22.05.2011, 00:38
- Forum: User Patches
- Topic: [patch_done] Fix datetime to string Lazarus program MySql
- Replies: 4
- Views: 2632
- 20.05.2011, 19:30
- Forum: ZeosLib 7.0 Beta Forum
- Topic: 7.0 SVN MySQL calculated field content is returned as ??
- Replies: 4
- Views: 753
- 20.05.2011, 03:30
- Forum: ZeosLib 7.0 Beta Forum
- Topic: 7.0 SVN MySQL calculated field content is returned as ??
- Replies: 4
- Views: 753
7.0 SVN MySQL calculated field content is returned as ??
The following SQL statement executed on a MySQL 5.x table with TZQuery SELECT DATE_FORMAT( CTime, '%Y/%m/%d' ) AS FClicked, count( * ) AS Cnt FROM TableName GROUP BY FClicked ORDER BY FClicked the field value of the result set field "FClicked" always returns '??' instead of the date values...