Subject Re: [ib-support] Re: minimizing transaction-open time
Author Louis Kleiman
This is exactly what a CDS does (actually the Provider does it, but...).

No need to roll your own anymore. Yeah!

Louis Kleiman

----- Original Message -----
From: Martijn Tonies
Sent: Wednesday, May 08, 2002 3:54 PM
Subject: Re: [ib-support] Re: minimizing transaction-open time


> Doug Chamberlin wrote:
> > Actually a much better way is
> > Start trans
> > Read record
> > Commit
> > Let user edit record taking all the time they want.
> > When they save:
> > Start trans
> > Write updates
> > Commit
> But you'll have to worry about whether you are updating the same database
> (as you read from) - you have to control every record that can be affected
> by the inserts/updates/deletes. Not impossible, but a chore.
> I use the timer approach (with commit or rollback), but this isn't without
> problems. I've found users returning from lunch and seeing their work has
> been rejected (rollback) having assumed that whatever they were editing
> (either in a grid or a separate form) has automagically been completed for
> them! Result: the record was never entered into the database.

We once created a system that updated only the modified column in this way:

update mytable set changecol1 = newvalue1, changecol2 = newvalue2
where idcolumn = idvalue and changecol1 = oldvalue1 and changecol2 =

If the update returned '0 rows affected' we would know there was a 'lock'

Worked great.

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird

Upscene Productions

"This is an object-oriented system.
If we change anything, the users object."

Yahoo! Groups Sponsor

To unsubscribe from this group, send an email to:

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

[Non-text portions of this message have been removed]