>if drawing data from a VFP free table using SQL statements on a server to a PC over a wireless network, is it better to "select to a cursor" or "select to a view"?
>
>What is the difference between a view and a cursor?
A cursor ("CURrent Set Of Records") is a temporary table, which might be created by a CREATE CURSOR command, by a query (SELECT - SQL statement), or by a view.
A view also includes a SELECT - SQL statement, plus some additional options.
I understand the query and the view as commands that produce cursors. The difference beween query and view is that the view is updatable (you can make changes to the cursor, and update the underlying tables).
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
