Subject Re: [IBO] Re: Concurrency problem and transactions
Author Jason Wharton
> BTW, is there a way IBO re-reads rows from the database when scrolling
> in the IB_Grid?

If you set the BufferSynchroFlags to bsfBeforeEdit you will get a refresh of
the record prior to going into edit state. I also recommend that you use
pessimisticlocking = true if its critical that two users do not edit the
same record at the same time.

You might also have a trigger bump a number on each update and then have the
update include that column in the where clause detecting a change from
someone else. You will then have to write special code in the OnUpdateError
event to query the new record value and prompt the user to compare them.
Plug in the new generator value and whatever changes required and resubmit
the update.

No matter how you slice it, there is going to be some work somewhere...

Jason Wharton
CPS - Mesa AZ