|| | |||Browse by category|
Running the following DBTools code produces different results with the 4.0.0 version
RWDBSelector sel = aDB.selector();
sel << rwdbCount();
sel.where(aDB.table(customer)[ID] > 3);
cout << sel.asString() << endl;
DBTools version 3.2.1
SELECT COUNT(*) FROM customer t0 WHERE t0.ID > 3
DBTools version 4.0.0
SELECT COUNT(*) FROM customer t0 WHERE t0.ID > :ph0
Version 4.0.0 of DBTools now uses bound expressions in all of the SQL statements it generates in order to speed up database access. The RWDBTracer class and asString() methods show the exact commands that have been sent to the database. This means the actual values of the bound expressions are not displayed using these methods.
DBTools version 4.10 and above versions provide an additonal feature for RWDBTracer to view the values passed into the placeholders.
Here is sample code
RWDBTracer& aTracer = db.tracer();