Hi Svein,

You gotta, now recordset is editable, now my next step is make a
master-detail relation. The query you saw is the master query and I
must join with another TIB_query as child. Could be possible with
actual master properties set?

Thanks a lot!

--- In IBObjects@yahoogroups.com, Svein Erling Tysvær
<svein.erling.tysvaer@k...> wrote:

>
> Helen answered:
> > In IBO, you can make one table in a joined set updatable by

setting the

> > KeyRelation property to the name of that table. The Keylinks must
> > include the primary key of that table. Set RequestLive true.
>
> Since the PK of A seems to be unique in the result set, you can

simply set

> KeyLinks to a.idparte, no need to involve any field from b in the

keylinks.

>
> Set
>
> --- In IBObjects@yahoogroups.com, "yartax1" wrote:
> >
> > When I said a "master query class", I tried to explain a class with
> > all the queries performed to bbdd. This class is like:
> >
> > class bbdd
> > {
> > AnsiString get_parte ( int usuario );
> > AnsiString get_revision ( int usuario );
> > ....
> > }
> >
> > This class returns AnsiStrings ( queries ) to pass to the TIB_Query.
> > This is good to separate form code from database code.
> >
> > In my case I want make the next query:
> >
> > Select a.*
> > from incidencia_parte a
> > inner join usuario_centro b
> > on a.centro = b.centro
> > where fbaja is null and idusuario=1
> > order by a.centro,fregistro
> >
> > Primary keys:
> > a.idparte
> > b.idusuario
> > b.centro
> >
> > My question is; this query is only possible in a procedure?