If you provide hand-written SQL for Update, RequestLive can stay
False. But if your query is "simple", RequestLive will make IBO build
the insert/update/delete SQL code for you. This is very useful since I
often add/remove fields from the query and I have not to check if
insert/update/delete is ok
regards
Marco Menardi

--- In IBObjects@yahoogroups.com, "tickerboo2002 <support@t...>"
<support@t...> wrote:

>
> > Is your query RequestLive set to true? And ReadOnly to false? Or, if
> > there is a join in the select, are you providing keylinks and
> > Keyrelation values?
>
> RequestLive was false, so I set it to true - still no joy. I've
> tracked it down to an error in the query's UpdateSQL, which caused a
> dozen exceptions to be thrown and silently caught.
>
> Note to self: check error log before posting.
>
> Thanks for your help.
>
> David