Open several cursor at once

[lustingray]

Hi,

Can I create an open several Cursor at once?

I will give an example:

Select * from test ;
join newtable on test.news = newtable.names into cursor XKPRO


Select * from test2 ;
join newtable on test2.news = newtable.names into cursor PGNST


Select * from test3 ;
join newtable on test3.news = newtable.names into cursor BHLJF


Now...



SELECT * FROM XKPRO;
INNER JOIN PGNST ON PGNST.ctry = XKPRO.names;
INNER JOIN BHLJF ON BHLJF.ctry like XKPRO.names;
INTO cursor MEGAFUS


Regards

Lu Stingray

 

[bborissov]

Why you need cursors for that?

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
Microsoft MVP VFP

 

[Mike Lewis]

Lu,

The answer is Yes. You can create many cursors at the same time. The code you showed is perfectly possible.

In this case, it would also be possible to do the whole thing with a single SELECT, without the intermediate cursors. But by all means do it the way you have, if you prefer.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk

 

[lustingray]

I just find the way more fast. I think be working with cursors, but according with yours it is not sure?

Thank you in advance

Lu Stingray

 

[lustingray]

Mike Lewis


How it is possible?

Best

Lu Stingray

 

[bborissov]

What version you use?

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
Microsoft MVP VFP

 

[lustingray]

VFP 9 SP2

thanks

Lu Stingray