Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Dataenvironment
Message
From
28/07/2009 07:59:09
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01414908
Message ID:
01415009
Views:
38
This message has been marked as a message which has helped to the initial question of the thread.
>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)
  • Previous
    Reply
    Map
    View

    Click here to load this message in the networking platform