Subject Re: [IBO] Re: Dropped feature in 4.5 ?
Author Helen Borrie
At 01:40 PM 29/11/2004 +0000, you wrote:

>Drop a query and a grid on a form and set a simple select as the
>query text.
>Set the query requestlive = false.
>With IBO 4.3 you could bring the dataset into insert state with IBO
>4.5 you can't !

Interesting!! In IBO 4.3 Aa, you *can*. In IBO 4.3Ab, you can't.

I found that, if I added FOR UPDATE to the query in 4.3b and in 4.5, it
toggled on the live dataset.

Just go back to the SQL property of that dataset, and check whether the
statement includes "FOR UPDATE". If it does, try removing
it. Alternatively, if it doesn't include it, try adding it...and report
the outcome. (The reason for trying one or the other is that FOR UPDATE
acts like a toggle...)

What I suspect is that Jason made it so that the FOR UPDATE clause is not
added by default to SELECT statements now, at a guess ,possibly to deal
with problems caused if one used Fb 1.5 FOR UPDATE WITH LOCK feature.