> SELECT ID
> , accID
> , (select account from account a where a.id=m.accid) as accountno // used
> to show actual account number in Grid
> , STATUS
> , BBANK
> , BACC
> , BNAME
> , BREGNO
> , BTAX
> , VALDATE
> , DOCDATE
> FROM dom_pay m
> join account on account.id=m.accid
> where account.uid='TH0000007' and account.install='test'
> for update

1. You could set KeyRelation=account and KeyLinks=PK of accounts(or columns
identifying uniquely a row)

2. You could modify the SQL:
SELECT ID
, accID
, (select account from account a where a.id=m.accid) as accountno // used
to show actual account number in Grid
, STATUS
, BBANK
, BACC
, BNAME
, BREGNO
, BTAX
, VALDATE
, DOCDATE
FROM account
join dom_pay m on account.id=m.accid
where account.uid='TH0000007' and account.install='test'
for update

With this you can't need set KeyRelation.

3. In last case you can use EditSQL,InsertSQL and DeleteSQL.

Luiz.

----- Original Message -----
From: Riho-Rene Ellermaa <r.ellermaa@...>
To: <IBObjects@egroups.com>
Sent: Wednesday, November 15, 2000 12:02 PM
Subject: RE: [IBO] IBObjects Help files


> Hello!
> I have a query
>
> SELECT ID
> , accID
> , (select account from account a where a.id=m.accid) as accountno // used
> to show actual account number in Grid
> , STATUS
> , BBANK
> , BACC
> , BNAME
> , BREGNO
> , BTAX
> , VALDATE
> , DOCDATE
> FROM dom_pay m
> join account on account.id=m.accid
> where account.uid='TH0000007' and account.install='test'
> for update
>
>
> How can i make this Query updatable?
> The help about JoinLinks just talked about its importants, but didn't say
> anything about how to use it.
>
>
> Riho-Rene Ellermaa
> senior programmer
> Hansabank
> >
>
>
>
>