No, not necessarily.
There's a lot of ways to skin this cat.

If you put in your own UpdateSQL then it is static. If you use certain
settings RequestLive will do various different behaviors. See
PreparedEdits, PreparedInserts, etc. Some people may only want the updated
values to be included in the statements put together. Some people may want
the key values in the WHERE clause others may want more columns to make sure
nothing changed on the server.

Jason Wharton

> -----Original Message-----
> From: Alan McDonald [mailto:alan@...]
> Sent: Monday, January 17, 2005 3:00 PM
> To: IBObjects@yahoogroups.com
> Subject: RE: [IBO] UpdateSQL
>
> > The code in the editor is different than the code that runs via
> > RequestLive.
> > Incorrect assumption.
> >
> > Jason
> I'll have at look at the monitor, but in what way is it
> different? Surely
> it's updating, inserting and deleting in the same way?
> Alan
>
> > > In Query components.. I click the generate SQL button, then I
> > > customise the
> > > SQL where necessary, then I uncheck the GenerateEditSQL,
> > > GenerateDeleteSQL
> > > and GenerateInsertSQL.
> > > Now I assume that where I leave the SQL empty and set
> > > requestlive to true,
> > > then the SQL generated will be the same as what I see
> > > when I click the
> > > Generate for Table button.. conversely, when I customise my
> > > own SQL and
> > > uncheck the checkboxes, then only my SQL will be used. Is
> > > this correct?
> > > If I customise AND leave the boxes checked - I also assume
> > > that no SQL will
> > > be generated?
> > > Alan
>