To that I get "Unable to initalize default LockSQL".

My query is

SELECT id,(select account from account a where a.id=dom_pay.accid) as
accountno
, ACCID
, STATUS
, BBANK
, BACC
, VER
...
, SIGN1
, SIGN2
, BANK
FROM account
join dom_pay on account.id=dom_pay.accid
where uid=:UID and install=:INST
for update


I let IBO generate EditSQL and InsertSQL, but what/where is this LockSQL?


Riho-Rene Ellermaa
senior programmer
Hansabank

> -----Original Message-----
> From: Andreas Pohl [mailto:apohl@...]
> Sent: Monday, October 15, 2001 12:34 PM
> To: IBObjects@yahoogroups.com
> Subject: Re: [IBO] Problem with multiple users editing
>
>
> TIB_Query.PessimisticLocking:=True and
> TIB_Query.IB_Connection:=tiCommited should do the job (at
> least to me:)
>
> Mit freundlichem Gruss & Best Regards
>
> Andreas Pohl
> apohl@...
> www.ibp-consult.com
> ----- Original Message -----
> From: "Riho-Rene Ellermaa" <r.ellermaa@...>
> To: "IBObject (E-mail)" <IBObjects@yahoogroups.com>
> Sent: Monday, October 15, 2001 12:03 PM
> Subject: [IBO] Problem with multiple users editing
>
>
> > Looks like I don't get this multiple users editing same
> record stuff.
> >
> > My transasction is tiCommited, AutoCommit=true, lockwait=false.
> > In BeforeEdit I call StartTransaction().
> >
> > But still, when I run two instances of my program, nothing
> stopps me from
> > editing same record in both programs. I start editing in 1,
> then start
> > editing in 2, post 1,post 2 - and the winner is 2.
> > Is the only solution to make EditSQL check all fields for
> old values? It
> > would be better to warn 2. user in the beginning, that this
> record is
> > already in edit mode.
> >
>
>
> ------------------------ Yahoo! Groups Sponsor
> ---------------------~-->
> Pinpoint the right security solution for your company- Learn
> how to add 128- bit encryption and to authenticate your web
> site with VeriSign's FREE guide!
> http://us.click.yahoo.com/yQix2C/33_CAA/yigFAA/PhFolB/TM
> --------------------------------------------------------------
> -------~->
>
>
>
> Your use of Yahoo! Groups is subject to

http://docs.yahoo.com/info/terms/