Devart Forums

I'm using 6.90.0.57 for D14
Hi here is an example:


Type
.
.

OraScript1: TOraScript;
OraSession1: TOraSession;
OraQuery1: TOraQuery;
private
procedure OraScriptBeforeExecute(Sender: TObject; var SQL: string; var Omit: Boolean);
.
.
.
begin
OraScript1 := TOraScript.Create(nil);
OraScript1 := OraScriptBeforeExecute;
OraScript1.SQL.Text := 'select * from dual where :Param1 = &Varible1 and 1 = 1';
OraScript1.ExecuteNext;
end;

procedure TForm1.OraScriptBeforeExecute(Sender: TObject; var SQL: string; var Omit: Boolean);
begin
// here the SQL String varible is like this "select * from dual where :Param1 = and 1 = 1"
// the "&Varible1" string is missing...Why???
end;

let's just forget about this question......This macro at work