I got some problem with query command(INSERT).
For example,
I inserted values (ID = 'user1', Name = 'delphi 6')in "my_DB" table.
But result is not normal.
By command(select), I found that "delphi 6" is in ID colum and "null" in Name colum.
this is source..
Code: Select all
var
i: Integer;
ver: WORD;
begin
...
With OraQuery1 Do Begin
SQL.Clear;
SQL.ADD('Insert Into My_DB(seq, reg_date, id, ver, name, note) ' +
'Values(:seq,:reg_date,:id,:ver,:name,:note)';
for i:=0 to ListView1.Items.Count -1 Do
begin
ParamByName('seq').Value:= i; // DB Type = Number
ParamByName('reg_date,').Value:= Now; // DB Type = Date
ParamByName('id').Value:= 'user1'; // DB Type = VarChar2(20)
ParamByName('ver').Value:= ver; // DB Type = Number
ParamByName('name').Value:= 'delphi6'; // DB Type = VarChar2(100)
ParamByName('note').Value:= NullString; // DB Type = VarChar2(100)
ExecSQL;
end;
Close;
End;
end;