Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Data of a cursor to be sent to SQL Server as a temp tabl
Message
 
To
19/08/2006 10:43:35
Dragan Nedeljkovich
Now officially retired
Zrenjanin, Serbia
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:
01146795
Message ID:
01147006
Views:
43
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
___________________________________________
Previous
Reply
Map
View

Click here to load this message in the networking platform