On Friday 09 May 2008 01:39:53 Al Baker wrote: > Quote " > > func_odbc can do whatever queries you give it. SELECT/UPDATE are > simply the simplest cases that make it easy to understand the > functionality" > > *OK - but are the Limited to SINGLE STATEMETS or can you have a > Muli-Statemnt Transaction ?*?
As we don't isolate connections to a single channel, we do not support multi-statement transactions, no. It's an interesting idea, though. Could you expound on what you would like to see? It may wind its way into a future version of func_odbc. Perhaps only three extra statements, one to start a transaction, which also reserves the connection handle to the channel (note that this would require turning off connection sharing, which is the default, except for TDS databases), one to commit, and one to rollback (the last two here would also release the connection handle back to the pool). Would that be sufficient? -- Tilghman _______________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
