QBE Bind variables again

[horst borscht]

Hi Marco,

I found this thread (https://forums.allroundautomations.com/ubb/ubbthreads.php?ubb=showflat&Number=8243&Searchpage=6&Main=2379&Words=qbe+bind&Search=true#Post8243) here in the forum. It seems to me you agreed to add the option to choose whether to use bind variables or not...

The readme file of Version 4.1 (for delphi XE2) now states that
"TOracleDataSet.QBEMode no longer uses variables for QBE values, but only uses literal values".

Could you please briefly explain why the use of bind variables for QBE is no longer supported?

Thanks in advance
Keep up the good work...

 

[Marco Kalter]

This was an old 4.0.0 change that does not apply specifically to 4.1.

 

[horst borscht]

Thanks for the quick answer, Marco.
But is there a specific reason for this change?
I ask this because like Mr Campos in the aforementioned post i witness lots of SQL using literals originating from QBE Queries filling up the shared pool. This does not actually kill the DB but I would like to know if there are any implications to be aware of...

Thanks again

 

[Marco Kalter]

Using literal values helps the optimizer to find the best approach to solve the query.

 

[horst borscht]

OK then,
Thanks Marco.