>Now it's clear for me
>
>The "cursors" I've been using for years in DE are just results from USE command
>
>But dealing with cursors from SQL commands seems more complex than DE "cursors"
>
>Now there are just some doubts:
>
>Which are the advantages of using SQL, instead of DE cursors?
>
>Will I have quicker search ? Is data corruption less likely to happen ?
Since it seems you have just started with views, here are some important points.
Views are stored in the database. You can easily access the view builder from the Project window.
Views can be updatable. This means that changes to the cursor (temporary table) can be sent back to the original tables, if you do a TableUpdate().
If you don't activate the "Master Switch" - labelled "Send Updates", other settings (like, which fields are updatable) don't have any effect.
If the view selects data from several tables, only one of them should be updateable.
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)