Hi Cristina,

Updating a view whose data fields come from more than one table can be -lots- of trouble. There can be issues with default values, triggers, primary key violations, null values, and a host of other "gotchas" that will cause you many headaches.

You might handle this more smoothly by creating a second, parameterized view containing the selected row or rows from ONLY the table you wish to update, populating those row(s), and then doing a TABLEUPDATE() on the smaller view. I've had success with this approach in several past apps.

HTH.

>I have a remote view with four tables. I want to update fields from only one
>table. When I insert a new record in my view and then I update with
>Tableupdate, the 1547 vfp error (Cannot insert an empty row from a view into
>its base table) appears. Why?
>
>--
>Regards,
>Cristina Bernárdez
>La Coruña - Spain