Code: Select all
CREATE TABLE a_t2
(
f1 integer NOT NULL,
f2 varchar(10) NOT NULL,
f3 float,
f4 TimeStamp,
PRIMARY KEY (f1, f2)
)
Code: Select all
procedure TForm1.Button1Click(Sender: TObject);
var V: Variant;
begin
V := null;
SQLQuery1.SQL.Text := 'INSERT INTO a_t2(f1, f2, f3, f4) VALUES(:A, :B, :C, :D) ';
SQLQuery1.Params[0].Value := 1;
SQLQuery1.Params[1].Value := '';
SQLQuery1.Params[2].Value := V;
SQLQuery1.Params[3].Clear();
SQLQuery1.ExecSQL(False);
end;
Code: Select all
2013/11/13 pm 02:14:47 n/a DBXPGSQL monitoring is started Complete
2013/11/13 pm 02:14:47 2.954 Execute: INSERT INTO a_t2(f1, f2, f3, f4) VALUES( $1 , $2 , $3 , $4 )
:1 (Int16,IN) = 1
:2 (WideString,IN)
:3 (Unknown,IN) = <NULL>
:4 (Unknown,IN) = <NULL>
Code: Select all
Column "f3" is of type double precision, but the expression is of type character varying