Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
One SPT cursor to be used in another SPT
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
Database:
MS SQL Server
Miscellaneous
Thread ID:
01135239
Message ID:
01135241
Views:
14
Hi Borislav

>>I have 2 SQL SELECT statements, executed one by one. The problem arise when I wanted to use the returned cursor of the first SPT in the second. The backend is SQL server.
>>
>>How can I acheive this? Please advise.
>
>How to use it?
>To update something or you want to use it to filtering data?

It is more like further JOINing. I mean the first SPT uses a few backend tables and creates a cursor in VFP. The second one again does a SPT, but this time the just created cursor is JOINed with another backend table to create a second cursor to be used seperately.

Hope this is what you wanted to know.
Regards
Bhavbhuti
___________________________________________
Softwares for Indian Businesses at:
http://venussoftop.tripod.com
___________________________________________
venussoftop@gmail.com
___________________________________________
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform