Subject | Unable to initialize default LockSQL error |
---|---|
Author | Riho-Rene Ellermaa |
Post date | 2001-09-04T13:45:02Z |
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
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