[asterisk-users] func_odbc creating records or best practice

[Tilghman Lesher]

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