Query problems Zeos 6.6.6, Lazarus 0.9.28.2b & Firebird

[guidoaerts]

silvioprog,
yes, your remark was good, but the translation was confusing.
guido

[christensen]

I do not understand you, I was shown this early in the thread:

silvioprog Posted: 18.05.2010, 16:48 (No subject)
Double quote ("1") mark in integer field, this works? I uses ('1').

But no problems, serves as a lesson for me.

For integer i haven't use any quotes only for varchar, like this:

Code: Select all

 ZQuery1.Close;
 ZQuery1.SQL.Clear;
 ZQuery1.SQL.Add('insert into proba(X_NAME, X_SURNAME, ADDRESS, PHONE) values (''Y'', ''O'', ''P'', 456)');
 ZQuery1.ExecSQL;

thanks again guys