Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
One SPT cursor to be used in another SPT
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 8 SP1
Database:
MS SQL Server
Divers
Thread ID:
01135239
Message ID:
01135241
Vues:
15
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
___________________________________________
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform