TOraScript Parser cuts my sql

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
dados
Posts: 82
Joined: Thu 18 Aug 2005 14:06

TOraScript Parser cuts my sql

Post by dados » Fri 27 Aug 2010 11:00

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;

dados
Posts: 82
Joined: Thu 18 Aug 2005 14:06

hmmm

Post by dados » Fri 27 Aug 2010 18:32

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

Post Reply