Hi,
I need to execute more than one inserts n updates and need these to be in a transaction.. how do i do this in dolphin?
Thanks,
Abhishek
Hi, I need to execute more than one inserts n updates and need these to be in a transaction.. how do i do this in dolphin? Thanks, Abhishek |
Hi everyone.. still waiting for someone to respond.. I need to execute 3 or more statements as part of a transaction.. Now, my understanding from looking at the code and specially BxDolDb.php is that, dolphin does not use transactions, it creates a persistent connection and uses elaborate start and close execution statements to handle the complexities that come with persistent connections. Now, in such a scene, i seems a little tough to execute transactions.. any ideas? How should i go about it? Thanks in advance! |
Your questions is not really related to dolphin. https://www.deanbassett.com |
Hi Deano.. thanks.. to simply put it, i need to execute all or none of more than one sql stmts from php code in dolphin.. This happens during the profile creation process. So as the profile table gets an insert, there should be 2 inserts in 2 new tables that i created. This is important for my system's functionality to work. If the updates in these tables do not happen then, the profile table insert should be rolled back. Going by what i understand from ur msg, isam is the engine and transactions cant be supported. Is there a way out or do i need to code checks and rollback manually to try simulate a transaction as close as i can? |
You will have to code it yourself. Perform each insert and if one fails then remove the previous ones. https://www.deanbassett.com |
thanks Deano.. |