30 Nov
2012
30 Nov
'12
10:58 a.m.
On Monday 26 November 2012 21:29:10 Brandon Armstead wrote:
Is there any reason to use sql_xquery vs sql_query?
Looking through the source it seems they both now handle the same or
similar data types?
It's not about datatypes, its about how you access the results.
sql_query() returns a resultset which can only be accessed by row and column
_numbers_. Further, the resultset is gone after processing the message.
sql_qxuery() stores the resultset in named xavp's. The columns can be accessed
by _name_. Because the resultset is in xavp's, it is stored in the transaction
and can be (re)used in onreply_route and failure_route.
To be complete, there is also sql_pvquery(), which is like avp_db_query() on
steroids. It allows the results to be assigned to arbitrary PV's instead of
just avp's.
Which one you use depends on your use-case.
--
Alex Hermann