Subject Re: [IBO] PreparedEdits does not work as expected?
Author Lester Caine
> Perhaps you are right, but I would think "a DSQL statement for just
> the updated columns should be constructed and immediately executed"
> means skipping the prepare stage.

BUT if you create a new DSQL statement, the FIRST thing
before using it is that it has to be prepared.
To USE the 'PreparedEdit' and avoid a new prepare,
'PreparedEdits = true'

One of the nice things about IBO is the way it hides a lot
of this away, and one forgets what is actually happening
underneath.

> For example, a table with many
> large fields, it will save traffic by only sending the changes
> instead of all data fields. If you use one prepared update statement,
> you will send all data fields.

Correct, but ANY new DSQL will have to be prepared, so it is
the combination of 'New Prepare + Shorter Statement' against
the 'All Fields Statement'.

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services