Zeoslib Portal

check this

http://zeos.firmos.at/viewtopic.php?t=4 ... t=compress

try to add this unit ZDbcIntfs

hi

i didnt test it but maybe this may work

query.Sql.Add('SELECT * FROM people');
query.Sql.Add('WHERE age > 30');
query.Sql.Add(':macro ');

if z then
query.ParamByName('macro').AsString := 'AND gender = ''M'''
else
query.ParamByName('macro').AsString := '';

try to use QyZEOS->SQL->Text->Clear before SELECT query

i know this metod but this is not what i looking for.
i can call ZConnection.PingServer before every query but Is there a way to detect connection lost without test it before each SQL command I run ?

I use MySQL. how can i raise and catch this exception?
i know how to handle exceptions for query but not for connection

and sorry for my english

i also need to solve this.
or is there posibility to catch this error and print my own error dialog
like "Database server error, please call your administrator"?

can somebody help?

try this with ZQUERY1 do begin SQL.Clear; SQL.Add('INSERT INTO table_profession_rubric (key_profession, key_rubric) '); SQL.Add('VALUES (:arg_key_profession, :arg_key_rubric); '); ParamByName('arg_key_profession')... ParamByName('arg_key_profession')... ExecSQL; Close; SQL.Clear; SQL.Add('SELECT LAS...

uses ZDbcIntfs; try with ZQUERY1 do begin SQL.Clear; SQL.Add('DELETE FROM books WHERE id_book=:Par '); ParamByName('Par').AsInteger := DBGrid1.DataSource.DataSet.FieldByName('id_book').AsInteger; ExecSQL; Close; end; except on E: EZSQLException do if E.ErrorCode = 1451 then begin Application.Message...

I have also this problem. TZQuery is mutch faster but if I set ReadOnly=True it is slow as a TZReadOnlyQuery.
Sorry for my english

Yes. i have the same problem with winrar. now i use total commander to extract it without problems.

P.S. Sorry for my english

Thank you for your quick answer.

I think I am stupid because I can not understand this source code.
Please can you send me a demo application?
My email : is@tsu.sk

P.S. sorry for my english

I have the same problem. Did you solve it?

"Firebird is completely free of any registration, licensing or deployment fees. It may be deployed freely for use with any third-party software, whether commercial or not." - www.firebirdsql.org

Specifically: * MySQL is free use for those who are 100% GPL. If your application is licensed under GPL or compatible OSI license approved by MySQL AB, you are free to ship any GPL software of MySQL AB with your application ('application' means any type of software application, system, tool or utili...