Subject Re: [IBO] Updating updated fields only
Author Helen Borrie
At 01:31 PM 31/03/2005 -0800, you wrote:

>I've got a bit of a problem here that I hope is fixable.
>Is there a way to tell IBO datasets (either native or TDataset compatible)
>to update only those fields that have changed. My current issue is with the
>If I remember correctly, the TQuery had an UpdateMode which lets us specify
>upWhereAll, upWhereChanged, upWhereKeyOnly.

You remember incorrectly. UpdateMode was a BDE-specific property and it
had nothing to do with "updating only those fields that have changed". It
specifies how the BDE searches for the records it has to update. So, for
example, you could specify UpdateWhereAll if the structure being updated
was not a keyed structure, e.g. a spreadsheet or a delimited text
file. The WHERE clause would then contain a search/match criterion for
every OLD value in the record.

>I *really* hope IBO has this functionality.

Do you understand that IB/Fb updates are always row-level, i.e. the old
version of a row is totally replaced by a new version?

Better to describe what is it that you need to do but can't.