Hello All,
I just can't seem to figure out from the SOCI documentation how to create a
prepared statement that returns a rowset<row> and to reuse this prepared
statement with multiple method calls.
All of the examples I have seen have the prepare and execution of the statement
in the same statement. I am looking to prepare a select statement that returns
a rowset<row> at the beginning of the program then use the prepared statement
in multiple method calls changing the filter via dynamic binding. Examples
show using prepared statements of non-select queries or single field returned
select queries but not one that returns a rowset. I am just looking for a way
to not go through the overhead of preparing the statement each time. Any ideas?
Sorry if I missed something obvious.
Thanks,
John
------------------------------------------------------------------------------
Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)!
Finally, a world-class log management solution at an even better price-free!
Download using promo code Free_Logger_4_Dev2Dev. Offer expires
February 28th, so secure your free ArcSight Logger TODAY!
http://p.sf.net/sfu/arcsight-sfd2d
_______________________________________________
Soci-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/soci-users