Subject Re: [IBO] cursors and opening for update
Author Helen Borrie
At 01:43 PM 18/06/2004 +0000, you wrote:
>i looked at the output for one of my cursors that is read only, will
>all edits/updates/inserts etc. turned to false, with a read-only
>transaction component as well using ib_monitor...the output indicates
>that IBO prepares the cursor for updating...if there is no updating
>possible, why does it prepare it for updating.

"FOR UPDATE" does not prepare a cursor for updating: it causes rows to be
fetched from the server one-by-one.

In fact, the server doesn't deliver "updatable" sets at all. It is the
methods and properties of your data access objects that determines whether
you can change, add or delete rows that underlie your sets.