Re: Transactions with ODBC

2008-01-25 Thread Peter Brawley
Does that mean what I did should have worked? I'd want to know (i) the result of executing those cmds in a mysql client, and (ii) what sqlresult & acountinfo contain after each cmd. PB [EMAIL PROTECTED] wrote: Thank you for your response. I am using InnoDB (picked that out of the docs). D

Re: Transactions with ODBC

2008-01-25 Thread groups
Thank you for your response. I am using InnoDB (picked that out of the docs). Does that mean what I did should have worked? I should not have had 2 rows in that table after running the commands? Thanks again... >I would like to wrap my updates top MySQL in transactions. Use InnoDB tables.

Re: Transactions with ODBC

2008-01-25 Thread Peter Brawley
I would like to wrap my updates top MySQL in transactions. Use InnoDB tables. PB [EMAIL PROTECTED] wrote: I apologize if you saw this on the MySQL Forums but I have not gotten a response... Thanks for your help... I know this is probably a stupid question but I could use a nudge in the righ