Helen is talking about a joined set, i.e. a set consisting of fields
from several other sets. Earlier in her reply she has covered updating
only one set, here she is talking about updating more than one. I
think xxxxSQL properties use DSQLs, and you cannot have more than one
statement in a DSQL. Though the idea of xxxxScript properties sounds
like an interesting thought to me (I'm lazy and would rather write a
couple of SQL statements than one stored procedure)...

Set

--- In IBObjects@yahoogroups.com, "Salvatore Besso" wrote:
> hello Helen,
>
> > You DO need a SP to make your joined set updatable
>
> just a curiosity: Is a SP really needed in this case or is it enough
> to fill the various XXXXSQL properties of the IB_Query? Isn't it the
> same in this case? I know that a IB_Query supplied with the XXXXSQL
> properties can update joined sets. So why a SP if the statement has
> to update only one table?
>
> Cheers
> Salvatore