Did you set RequestLive to true?

Jason Wharton
www.ibobjects.com

> -----Original Message-----
> From: danielrail [mailto:daniel@...]
> Sent: Thursday, April 07, 2005 10:54 AM
> To: IBObjects@yahoogroups.com
> Subject: Re: [IBO] Updating updated fields only
>
>
>
>
> --- In IBObjects@yahoogroups.com, "Jason Wharton" <jwharton@i...>
> wrote:
> > Kevin,
> >
> > > 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
> > > TIB_Query.
> > >
> > > If I remember correctly, the TQuery had an UpdateMode which
> > > lets us specify
> > > upWhereAll, upWhereChanged, upWhereKeyOnly.
> > >
> > > I *really* hope IBO has this functionality.
> >
> > IBO does have some ways to influence things along these lines.
> >
> > There is a property PreparedEdits that determines if only changed
> fields are
> > included in the UPDATE SQL that is sent to the server or if a
> prepared
> > UPDATE SQL is held for all fields and kept prepared and every time
> a change
> > is posted all column values are submitted. By default it uses a
> prepared
> > edit statement and submits all column values. Setting it to false
> allows
> > IBO to generate a unique SQL for each record posting including only
> changed
> > columns.
>
> This doesn't work for me, and I'm also using TIBOQuery. If I omit
> the EditSQL(UPDATE statement) and set PreparedEdits to False, the
> dataset is marked as not updatable, even if there's no aggregate
> fields and only one table is in the query. And, if I put a statement
> in EditSQL and set PreparedEdits to False, then the full UPDATE
> statement as defined in EditSQL is used. I haven't checked with
> TIB_Query to see if it handles this better, which I probably would
> expect it to.
>
> Daniel Rail