If you are locking there isn't an update done yet so use the column directly
without the OLD_ prefix. I may not be checking for it in the LockSQL.
Ideally it should allow you to do that.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Manel Sánchez-Maulini" <ms.maulini@...>
To: <IBObjects@yahoogroups.com>
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:
> UPDATE MYTABLE SET
> MYCOL1 = MYCOL1
> WHERE MYKEY = :OLD_MYKEY
>
> 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 http://docs.yahoo.com/info/terms/
>
>