SubstitutedSQL method

[TomC]

What is the secret to obtaining a result from method TOracleDataSet.SubstitutedSQL that actually contains my variables substituted with the values I have set using method SetVariable?

Any help would be much appreciated.

Tom Clowers

 

[Marco Kalter]

Only substitution variables are substituted in the SubstitutedSQL function. All other variables (string, integer, date, float, ...) are bind variables and will be sent to the Oracle Server in an internal format, along with the unaltered SQL statement.

------------------
Marco Kalter
Allround Automations