Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Dataenvironment
Message
De
28/07/2009 07:59:09
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Titre:
Versions des environnements
Visual FoxPro:
VFP 9 SP2
Divers
Thread ID:
01414908
Message ID:
01415009
Vues:
37
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)
  • Précédent
    Répondre
    Fil
    Voir

    Click here to load this message in the networking platform