Page 2 of 2

Posted: 21.05.2010, 10:52
by guidoaerts
silvioprog,
yes, your remark was good, but the translation was confusing.
guido

Posted: 21.05.2010, 15:37
by christensen
silvioprog wrote: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. 8)
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