[asterisk-users] func_odbc creating records or best practice

[Al Baker]

I would love to be able to issues the necessary Mysql commands to have 
true TRANSACTIONS
Such as - Begin Transaction
               Select @var=agent.id, agent.exstension where 
agent.status='free'
                Update agent.status='BUSY' where agent.id=@var
                End Transaction
Of Course the syntax I used above is just psuedo-code and NOT correct MySQL
but I think you can see what I am trying to do. Which I think would be 
darn handy !!!

Tilghman Lesher wrote:
> 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?
>
>