Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Update the View
Message
 
 
To
01/12/2000 22:38:17
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00448419
Message ID:
00448483
Views:
7
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform