Helen,

I already use keylinks

keylinks:
myTable.ID
myTable.checkField

if checkfield has changed I get this exception, like expected.
I press cancel and edit/post again to see if it will update the second time
and then the line clears, sometimes without message, sometimes with message
"field ID is a required field", and that's because the row is made empty by
IBO

Leon


"Helen Borrie" <helebor@...> wrote in message
news:5.2.0.9.2.20030730235803.01bb2000@......

> Leon,
>
> At 04:00 PM 30/07/2003 +0200, you wrote:
> >Hi,
> >
> >IBO generates a nice exception if a record to update can't be found

anymore.

> >If it does it kind of erases the corresponding record from memory leaving

an

> >empty row. ( TIBOquery )
>
> Not exactly...
>
> >I would like to catch the exception and choose how IBO is to behave.
> >
> >I use an editSQL like "UPDATE ...SET ...WHERE id=:old_id AND
> >checkfield=:old_checkfield". I use "checkfield" to perform a

multiusercheck.

> >If checkfield has changed I want to cancel the update. It's very annoying

if

> >after the "can't locate record for update" message the line goes blank.
> >
> >Is there a way to change this behaviour ?
>
> Yes, use KeyLinks, and don't design interfaces where your users can change
> the primary key. Then you can let IBO do what IBO does - keep track of

all

> your records. You don't need that stuff you're doing there - IBO does it
> itself.
>
> Helen
>
>
>
>
>

___________________________________________________________________________

> IB Objects - direct, complete, custom connectivity to Firebird or

InterBase

> without the need for BDE, ODBC or any other layer.
>

___________________________________________________________________________

> http://www.ibobjects.com - your IBO community resource for Tech Info

papers,

> keyword-searchable FAQ, community code contributions and more !
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>