ODAC will automatically create the Params for TOraSQL?

[akiraiu]

Here part of Code:

Code: Select all

var OraSQL : TOraSQL;
.........
OraSQL.SQL.Add ('insert into test (a, b, c) values (:a, :b, :c)');
OraSQL.ParamByName ('a').AsString := '111';
OraSQL.ParamByName ('b').AsInteger := 222;
OraSQL.ParamByName ('c').AsString := '333';
OraSQL.Execute;
.......

Here I have test table:

Code: Select all

create table test (
  a Varchar2 (10),
  b Number (10),
  c Varchar2 (10)
);

ODAC TOraSQL will help me to create the parameters??

[Alex]

TOraSQL automatically scans SQL and creates parameters when ParamCheck property is set.

[akiraiu]

OK. For Above example, I want to Insert the unicode for the column a and c:

Code: Select all

var OraSQL : TOraSQL; 
......... 
OraSQL.SQL.Add ('insert into test (a, b, c) values (:a, :b, :c)'); 
OraSQL.ParamByName ('a').AsWideString := '111'; 
OraSQL.ParamByName ('b').AsInteger := 222; 
OraSQL.ParamByName ('c').AsWideString := '333'; 
OraSQL.Execute; 

then ODAC create the parameters type is ftString or ftWideString?

[Alex]

Please see "Working with Unicode character data" topic of ODAC help