Re: [GENERAL] Nested transaction - I am a bank ??

2004-01-14 Thread Paul Thomas
On 14/01/2004 00:17 Nigel J. Andrews wrote: On Tue, 13 Jan 2004, Thapliyal, Deepak wrote: Thx Nigel.. Also can you kindly advice how to turn autocommit to off Probably: SET AUTOCOMMIT TO OFF; although I'm not sure that is still there in 7.4 and there was a lot of discussion on it's

Re: [GENERAL] Nested transaction - I am a bank ??

2004-01-14 Thread David Garamond
Thapliyal, Deepak wrote: Hi, Assume I have a bank app.. When customer withdraws $10 from his accouint I have to do following -- update account_summary table [subtract $10 from his account] -- update account detail_table [with other transaction details] Requirement: either both transactions

[GENERAL] Nested transaction - I am a bank ??

2004-01-13 Thread Thapliyal, Deepak
Hi, Assume I have a bank app.. When customer withdraws $10 from his accouint I have to do following -- update account_summary table [subtract $10 from his account] -- update account detail_table [with other transaction details] Requirement: either both transactions

Re: [GENERAL] Nested transaction - I am a bank ??

2004-01-13 Thread Joshua D. Drake
Thapliyal, Deepak wrote: Hi, Assume I have a bank app.. When customer withdraws $10 from his accouint I have to do following -- update account_summary table [subtract $10 from his account] -- update account detail_table [with other transaction details] Requirement: either both transactions

[GENERAL] Nested transaction - I am a bank ??

2004-01-13 Thread Thapliyal, Deepak
] Nested transaction - I am a bank ?? Thapliyal, Deepak wrote: Hi, Assume I have a bank app.. When customer withdraws $10 from his accouint I have to do following -- update account_summary table [subtract $10 from his account] -- update account detail_table [with other transaction

Re: [GENERAL] Nested transaction - I am a bank ??

2004-01-13 Thread Richard Huxton
On Tuesday 13 January 2004 17:47, Thapliyal, Deepak wrote: Hi, Assume I have a bank app.. When customer withdraws $10 from his accouint I have to do following -- update account_summary table [subtract $10 from his account] -- update account detail_table [with other transaction