Subject Re: [IBO] Possible BDE/DBase -> FB 1.5/IBO Migration(Noob Questions Inside)
Author Svein Erling Tysvær
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)...


--- In, "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