Subject RE: [IBO] UpdateSQL
Author Alan McDonald
> 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