It doesn't know how to figure out the LockSQL so you need to manually supply
it.

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

----- Original Message -----
From: "Riho-Rene Ellermaa" <r.ellermaa@...>
To: "IBObject (ibobjects@egroups.com)" <IBObjects@yahoogroups.com>
Sent: Tuesday, September 04, 2001 6:45 AM
Subject: [IBO] Unable to initialize default LockSQL error


> I get this error in my IBO4 query. Never seen it before.
>
> SELECT id,(select account from account a where a.id=for_pay.accid) as
> accountno
> , ACCID
> , STATUS
> , BINFO
> , BTAX
> , IBANK
> , IACCOUNT
> , CREF
> , CBANK
> , BBANKNAME
> , IBANKNAME
> , CBANKNAME
> FROM account
> join for_pay on account.id=for_pay.accid
> where uid=:UID and install=:INST
> for update
>
> Pessimistic locking is checked (it was automatically on). I have
> automatically defined UpdateSQL sentences for for_pay table.
> Any reasons?
>
>
> Riho-Rene Ellermaa
> senior programmer
> Hansabank