----- Original Message -----
From: "mmenaz" <mmenaz@...>
> 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.