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.

Transactions with ODBC

2008-01-25 Thread groups
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 right direction. I would like to wrap my updates top MySQL in transactions. I am using ODBC as my means of

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).

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