>Sarosh,
>
>You may be able to fix this by changing the SQL WHERE clause to Key Fields Only on the update criteria tab of the view. You should be aware that if you do this the records in the dBase IV tables will be updated even if someone else changed them since you queried the tables. If your application is the only one changing the tables or if you can live with overwriting other user's changes, then this won't be a problem.
>

Josh,

Thank's for the help.

I have tried,
=DBSetProp(ViewName, 'View', 'WhereType', 3) and
=DBSetProp(ViewName, 'View', 'WhereType', 1) both these don't work.

In 3 out of the 5 dbase dbf's all the fields are characters, they update ok, the 4th dbf has on date field and that updates ok too, but the 5th table has 4 date fields and that gives me a data type mismatch error. If I change all the date fields in the 5th dbf to character fields then the updates work just fine.

By the way, I create these views through program code. If needed I can post the code which does that.

Sarosh