Search found 7 matches

by thcom
21.03.2012, 11:20
Forum: ZeosLib 7.0 Beta Forum
Topic: [patch_done] ZROQuery show czech characters OK, ZQuery don't
Replies: 3
Views: 595

thanks, i depply test it, and conclusion is
i dont need SET NAMES :)
when i use ClientCodePageOptions = cp1250 ZQuery shows bad characters :(
whe i use ClientCodePageOptions = utf8 ALL is WORKING fine

for other rededers, don't forget set coSetCodePageToConnection to true

so thank you
by thcom
20.03.2012, 14:04
Forum: ZeosLib 7.0 Beta Forum
Topic: [patch_done] ZROQuery show czech characters OK, ZQuery don't
Replies: 3
Views: 595

[patch_done] ZROQuery show czech characters OK, ZQuery don't

hi, in my app differs output from ZReadOnlyQuery and ZQuery, i use Delphi XE and i try zeoslib 667, v7 v8 v9 and today new branch from EgonHugeist (thanks for your great work !) i try to uncomment WITH_CLIENT_CODE_PAGE_OPTIONS, i try to study http://zeos.firmos.at/viewtopic.php?t=3427 but nothing he...
by thcom
29.09.2011, 13:02
Forum: ZeosLib 7.0 Beta Forum
Topic: Tokenizer EConvertError - DateTime
Replies: 3
Views: 931

hi, sorry for late answer, i try to change date and time separator, i use 'x' character, because we in czech republic use ':' as time separator and '.' as date separator.

my application is now working properly, but i have strange feeling ...
should i leave this hack in zeos source ?

thank you Tomas
by thcom
12.09.2011, 13:06
Forum: ZeosLib 7.0 Beta Forum
Topic: Tokenizer EConvertError - DateTime
Replies: 3
Views: 931

Tokenizer EConvertError - DateTime

hi, i am using Delphi 7 lite on Windows 7 with MySQL 5.1.41 when i use SQL statement like this DATE_FORMAT(test,"%H:%i:%s") AS test i get error EConvertError in IDE, in runtime is it OK i try to debug this strange thing, and i found ZGenericSqlToken.pas there is a method TZGenericSQLQuoteS...
by thcom
17.07.2008, 08:16
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: how to handle exception if MySQL server does not respond ?
Replies: 3
Views: 1029

i am sorry, its little weird, i create litle app with this try connect except block, and everything works fine, but in my big application shows exception only in Delphi IDE in runtime shows UNKNOWN exception :( should i setupo something in delphi menu tools - debug options - OS Exceptions ? i'm usin...
by thcom
16.07.2008, 20:09
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: how to handle exception if MySQL server does not respond ?
Replies: 3
Views: 1029

how to handle exception if MySQL server does not respond ?

hi, i try this code: function ConnectMySQL(iConexe: TZConnection; iIP: String; iDB : String): Boolean; begin Screen.Cursor := crSQLWait; ConnectMySQL := False; iConexe.HostName := iIP; iConexe.Database := iDB; try iConexe.Connect; ConnectMySQL := True; except on E:Exception do begin showMessage('Can...
by thcom
29.06.2007, 12:57
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: TZQuery - wrong determining of parameters type ?
Replies: 1
Views: 610

TZQuery - wrong determining of parameters type ?

hi, i run some easy update query with parameters qu_insert_polozka_.parambyname('param_count').value := 1; so the DataType is now ftSmallInt in second call of my query qu_insert_polozka_.parambyname('param_count').value := 40000; the DataType remains and the execution of query causes an range check ...