[Info-ingres] [Info-Ingres] API Scrollable Cursors ... is this EVIL expected?

[Ingres Forums]

geraintjones;49671 Wrote: 
> What would happen if you extended your scrollable cursor testing to a
> cursor that's reading from a row producing procedure? Surely there's
> some potential here for further evil.
I'm glad you asked that particularly EVIL question....

After some testing...

You can't define an updatable cursor on unstructured data (as produced
by a table procedure). You must have a primary key or unique index
involved. 

You can define a readonly cursor on the unstructured  data and hence use
a scrollable readonly cursor to read the data coming from the table
procedure....basically in any order you want.

Marty


-- 
martymonster
------------------------------------------------------------------------
martymonster's Profile: http://community.actian.com/forum/member.php?userid=113074
View this thread: http://community.actian.com/forum/showthread.php?t=16138