>Now I understood that select cursor are different from DE cursors
>
>And about their behaivour, are they the same ?
>
>For example in the way their data are saved to the table
The "Cursor" in the DataEnvironment can specify either a table or a view. The view is defined in the database.
About saving data to table... There is really no difference, whether you open the table (or view) in behavior, whether you open through a command in the Command Window, in Form.Load(), or in the DataEnvironment. The behavior for saving is as follows:
If you open a table without buffering, changes are saved directly to the table.
If you open a table with buffering, changes are kept in buffers, until you give TableUpdate(). You can also undo changes with TableRevert().
If you open a view, I believe the only option is to use buffering. Here, too, changes are saved when you give the command TableUpdate(), and can be un-done with TableRevert(). However, with a view, you change a record in the cursor resulting from the view; if you give the command TableUpdate(), Visual FoxPro tries to save data back to the original table or 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)
