Subject Re: [IBO] help: Locking and LockSQL
Author Manel Sánchez-Maulini

First at all many thanks for your help. Each time I have posted
something you answered straitforward, this is always motivating.
And now, I'm sorry for bothering you again.

I'm completely lost with locking behavior on a master-detail
relationship. I have tried what you said in your answer and I get
always the message "Record locked by another user" even with an unique
user. If I leave the lockSQL properly blank, locking works for the
current detail register with the message "Deadlock" but it does not
work if you try to update other line, then no locking is performed.

Trying to work with KeyLinks but I could not afford to put a "correct"
syntax in that field. Each time I put different table the query
editor gives an error, something like "unproper field".

I used to work with BDE and I locked the master table when you are
working either on the header or on the lines. Should be done the same
way here ? Is there any better way?

At the end I get pessimistic locking working for detail or master but
no both. Is this the correct way of proceeding?

I have the starting guide of IBObjects and there is neither a specific
policy nor some guideline to be followed. If you can advise me about
any documentation I will be very pleased.

Thanks again for your job,.
Nice regards,
Manel Sanchez Maulini
Barcelona - Spain

--- In IBObjects@y..., "Jason Wharton" <jwharton@...> wrote:
> If you are locking there isn't an update done yet so use the column
> without the OLD_ prefix. I may not be checking for it in the
> Ideally it should allow you to do that.
> Jason Wharton
> CPS - Mesa AZ
> ----- Original Message -----
> From: "Manel Sánchez-Maulini" <ms.maulini@a...>
> To: <IBObjects@y...>
> Sent: Friday, May 25, 2001 11:47 AM
> Subject: [IBO] help: LockSQL
> > We are trying to use lockSQL property to get header lock when the
> > user accesses the lines on a master-detail relationship.
> > We wrote the sql property in the following way:
> >
> > as indicated in IBO help, but we get a DML error:
> > Invalid custom DML reference column OLD_MYKEY
> >
> > We have checked several times the sentence syntax and, of course,
> > MYKEY exists and belongs to MYTABLE.
> >
> > Any help will be wellcome, thanks in advance.
> > Manel
> >
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
> >
> >