Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

multiple cursors

Status
Not open for further replies.

Cagliostro

Programmer
Sep 13, 2000
4,226
GB
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
1c.bmp


filipski@excite.com
 
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
 
put a please sample if is possible Ion Filipski
1c.bmp


filipski@excite.com
 
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
 
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
1c.bmp


filipski@excite.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top