Subject Re: [firebird-support] How to lock a record and check locked or not.
Author Helen Borrie
At 12:41 PM 9/09/2003 +0900, you wrote:

>To find failed or succeeded, Catch exception or not ?

Yes, you must catch the exception and apply code to "reset" the
condition. The cleanest way is to cancel the edit and roll back the
transaction.

>Or other way to find ?

No: this is what exceptions are for.


>Once exception occured, IBX functions do not work at all.
>(Displayed "lock conflict on no wait transaction" message)
>Is there any good way to continue a program ?

Yes: you must handle the exception, as described above.


> > It would be worth asking at borland.public.delphi.interbasexpress on
> > news://forums.borland.com, whether there is a version of IBX that
> > implements pessimistic locking for you (as IBObjects does). It will make
> > your task much simpler...
> >
>
>I checked news://forums.borland.com, but now delphi news was not at all.
>many csharpbuilder news.

There are still lots of public.delphi groups there!! But ----
public.delphi.database.interbasexpress (sorry!)
^^^^^^^^^^^^^^^

heLen