>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.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao