RE: Can I update sql cursor data?

No, I think the original poster wants to open a cursor, make a pass through
it updating fields as if it were a temporary file but without updating the
actual file, and then re-read the cursor from the beginning with the
changes.

It's an interesting request, but as far as I know it can't be done.

Joe

From: Michael Ryan

What does "update the cursor data" mean? Do you want to select a row from
a
file into host variables and then change the contents of the host
variables?
There's nothing special about that. Just fetch the data and change it. The
file won't be updated unless you use the UPDATE or INSERT SQL verbs.

On 9/3/06, 2046 BBQ <2046bbq@xxxxxxxxx> wrote:

I tried this statement before, it will also update cursor data and

actual

PF,
i just want update the cursor data, not the PF.