Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Data of a cursor to be sent to SQL Server as a temp tabl
Message
 
À
19/08/2006 10:43:35
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
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:
01146795
Message ID:
01147006
Vues:
40
Hi Dragan

>You create a SPT cursor from that table with sqlexec(h, "select * from #temp", "mycursor"), then cursorsetprop() a bunch of things for that cursor - update tables, primary key, update fields, pretty much the same way VFP does it for the updatable views. Then you fill the cursor and do a tableupdate(). You can find the code here in either downloads or FAQ - look for Vlad Grynchyshyn, he wrote that.

Thanks checking it out now.
Regards
Bhavbhuti
___________________________________________
Softwares for Indian Businesses at:
http://venussoftop.tripod.com
___________________________________________
venussoftop@gmail.com
___________________________________________
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform