multiple cursors

[Cagliostro]

Hi,
Is there a posibility of using moltiple corsors simultaneously? Is so, how can I do it and how can I know which cursor is fetched to last record and which not? Ion Filipski

filipski@excite.com

 

[jjonesal]

You CAN use several cursors simultaneously (local or global)....Just declare them with different names. But be careful when using the @@FETCH_STATUS because it always contains status of most recent fetch. (so you have to check @@FETCH_STATUS before any other FETCH is issued against another cursor)

J. Jones
jjones@cybrtyme.com

 

[Cagliostro]

put a please sample if is possible Ion Filipski

filipski@excite.com

 

[jjonesal]

Can you give me a brief description of what you are trying to do and I'll try to give you an example.... J. Jones
jjones@cybrtyme.com

 

[Cagliostro]

give please it in pseudocode.

declare xxx cursor for...
declare yyy cursor for...
open xxx
open yyy
while ..... ---xxx is not at the end
begin
fetch next from xxx
while ..... ---yyy is not at the end
begin
fetch next from yyy
....
end
end Ion Filipski

filipski@excite.com