RE: Can I update sql cursor data?

[R Bruce Hoffman <bruce.hoffman@xxxxxxxxxxxxxxxxx>]

well, a read trigger can modify the returned data, but it would have to
change it each time the record is read from the table.


On Sun, 2006-09-03 at 15:53 -0500, Joe Pluta wrote:
> 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.