Hi

> If I remember correctly (need to check sources), that your SELECT will be
> fetched first to the client completely, before you will be able to perform

any

> operation on result set (the SCROLL_INSENSITIVE flag should instantiate a

so-

> called cached result set, which means - "first cache everything in memory,
> then allow operations on result set).

That's something I feared.

> The only flag that does not perform result set caching is FORWARD__ONLY,
> but I am not sure tthat it is compatible with the UPDATABLE result set.

Obviously that would be very intresting form e.
Would it be hard to check?

> The approach with one statement for SELECT (no flags will mean
> FORWARD_ONLY and READ_ONLY) and one statement for updates is better -
> in that case you are in control of everything. Just remember to switch-off

the

> auto-commit mode.

Autocommit is off, of course.


Cheers,
Steffen



[Non-text portions of this message have been removed]