Page 1 of 1

Parsing SQL parameters without executing query?

Posted: Thu 05 May 2016 11:06
by pcz
Hello

Is it possible to generate "parsed" SQL without opening / preparing query at all? (by "parsed" I mean "like FinalSQL but with parameter values assignment block")

I just like to use TOraQuery parsing without getting any data

Example:
I'd like to have TOraQuery with code like:

Code: Select all

SELECT KEY_VALUE FROM TABLE WHERE NAME_VALUE = :PARAM
and just want to set "PARAM" value and read string with parameter values:

Code: Select all

SELECT KEY_VALUE FROM TABLE WHERE NAME_VALUE = :PARAM

:PARAM(Unknown)='xyz'
Regards
P.C.

Re: Parsing SQL parameters without executing query?

Posted: Fri 06 May 2016 08:17
by MaximG
Unfortunately, this option is not available in ODAC, and the developers need to implement it on their own.

Re: Parsing SQL parameters without executing query?

Posted: Fri 06 May 2016 08:20
by pcz
Ok - thank You for information!