Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Update the View
Message
 
 
À
01/12/2000 22:38:17
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00448419
Message ID:
00448483
Vues:
10
>There is a table but no any index such as regular, primary ...
>Then I crate a view from this table.
>When I update the view, the view is updated, but the actural table does not updated!
>How can I update the actural table from the view?

Just to exapnd on what Cetin said (because you need those settings for it to work at all), without indexes, if it works it will work slowly.

When you set up a key field for a view, VFP attepts to do an UPDATE ... WHERE on the table when you Tableupdate the view. If there are no indexes, the SQL Update is not optimizable and VFP has to examine the entire table. If your table grows to any size at all, you will have major performance issues.
Larry Miller
MCSD
LWMiller3@verizon.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform