Re: [firebird-support] A question about WAIT

2013-01-07 Thread W O
Thank you very much Alan, your explanation was very clear. Greetings. Walter. On Mon, Jan 7, 2013 at 8:51 PM, Alan McDonald wrote: > ** > > > > Thank you very much Alan for your answer. > > > > How do you use dummy updates, can explain me more about that > > technique? > > > > Greetings. >

RE: [firebird-support] A question about WAIT

2013-01-07 Thread Alan McDonald
> Thank you very much Alan for your answer. > > How do you use dummy updates, can explain me more about that > technique? > > Greetings. > > Walter. > If you get the Firebird book you will have a complete explanation. You need to understand transaction settings little better. In short, if you

Re: [firebird-support] A question about WAIT

2013-01-07 Thread W O
Thank you very much Alan for your answer. How do you use dummy updates, can explain me more about that technique? Greetings. Walter. On Mon, Jan 7, 2013 at 6:32 PM, Alan McDonald wrote: > ** > > > If 526 commits, then 535 will need to re-acquire before a successfull > update, > If 526 rol

Re: [firebird-support] A question about WAIT

2013-01-07 Thread Alan McDonald
If 526 commits, then 535 will need to re-acquire before a successfull update, If 526 rolls back, then 535 could proceed with existing 'stalled' edits but the WAIT option is clumcy for the user... there's no way of knowing how long they have to wait. I repeat, you are better off preventing 535 from