Hello:

I have looked in the help files for both keylinks and keyrelation and
don't understand how these can be used to allow me to edit a column
in the grid. Can you be more specific. Thanks.

--- In IBObjects@y..., "Luiz" <cprmlao@i...> wrote:
>
> ----- Original Message -----
> From: "mmenaz" <mmenaz@l...>
>
>
> > First of all, you'd really better use the ANSISQL syntax for the
> > joins, since it's the syntax IBO uderstands better (or
understands).
> > Something like:
> > SELECT PROJECT.PROJ_NAME,
> > PROJECT.PROJ_DESC,
> > PROJ_DEPT_BUDGET.DEPT_NO,
> > PROJ_DEPT_BUDGET.QUART_HEAD_CNT
> > FROM PROJECT
> > INNER JOIN PROJ_DEPT_BUDGET ON (PROJECT.PROJ_ID =
> > PROJ_DEPT_BUDGET.PROJ_ID)
> >
> > Second, joins are uneditable without special care, since what
fields
> > and of what table are to be edited?
> > Ibo gives you tha flexibility of simply specify the table of the
join
> > you want to edit using the 'KeyRelation', or provide custom stored
> > procedure.
> > From IBO help:
> > ------
> > Declaration
> > Property KeyRelation;
> > Description
> > It is possible to make a dataset that is output from a join
between
> > tables capable of inserts and deletes without custom SQL, by
> > indicating which relation these operations should be applied to.
> >
> > Observe that only one table can be subjected to update or delete
> > operations by this means. If you need to make the insert, update
and
> > delete methods operate on two or more of the tables, stored
procedures
> > will be required. Refer to the InsertSQL, EditSQL and DeleteSQL
> > properties.
> > ------
>
> Just an additional comment, don't forget to configure KeyLinks
property
> also.
> Generally, in simple querys as showed for Marco, it´s not necessary
to
> configure KeyRelation.
>
> Luiz.