The difference: SQLDialect=1 and SQLDialect=3. Give comments!

[Guest_imported]

Using Interbase and Delphi,
I try this using SQLDialect=1, but don't work, because there
are a field in database that is type "date".

ibQuery1.Close;
ibQuery1.SQL.Clear;
ibQuery1.SQL.Add ('INSERT INTO test2 ("' + edit1.text + '", "' + edit2.text + '&quot');
ibQuery1.ExecSQL;

Using SQLDialect=3, I solve the problem by pass the parameters like this:

ibQuery1.Close;
ibQuery1.SQL.Clear;
ibQuery1.SQL.Add ('INSERT INTO test2 PARAM1, ARAM2)');
ibquery1.params[0].asdate:=edit1.text;
ibquery1.params[1].asstring:=edit2.text;
ibQuery1.ExecSQL;

I expect that this help some of you.

 

[StevenK]

It looks like you followed my previous advice on this matter. It's probably worth noting that in the first instance you were trying to use a String for feeding in the 'date' data-type. The query component attempts to determine what is to be posted to this 'date' field and finds a string. It therefore returns a warning.
Not made use of the SQLDialect before myself ....
Steve