Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Updateable cursors from SQL Server 2000?
Message
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Updateable cursors from SQL Server 2000?
Miscellaneous
Thread ID:
00483018
Message ID:
00483018
Views:
64
I just did a scan loop on an empty field returned from SQL Server 2000 with SQL-Passthrough replacing each row's field with a different number.

I thought cursors returned with Spt were by default readonly?

Is this something new with VFP7? Help doesn't seem to mention it.

Anyone know anything about this? It caused a ten times speed improvement (according to the profiler) over converting the cursor to updateable with the usual:
use dbf("cursor") again in 0 alias newcursor
Next
Reply
Map
View

Click here to load this message in the networking platform