Parsing SQL parameters without executing query?

[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.

[MaximG]

Unfortunately, this option is not available in ODAC, and the developers need to implement it on their own.

[pcz]

Ok - thank You for information!