Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Does SQL move the record pointer after query
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00746981
Message ID:
00747465
Views:
14
Got that right!

But SQL cursors work on the server so if you have to do Year End purging to a history file SQL Cursors won't kill your bandwidth like VFP can.

__Stephen

>SQL is a set based language, there is no concept of a record pointer like in xBase. However, there is one exception, SQL cursors, which let you work iteratively (row-by-row). Just for grins, compare a SQL cursor with a VFP cursor. The VFP cursor is a million times better!
>
>Charlie
Previous
Reply
Map
View

Click here to load this message in the networking platform