Hi Jim,
In addition to Erik's suggestion, take a look at what the field names are. I ran into this same problem and it drive me nuts until I discovered that, apparently, views only respect the first 15 characters (or so) of a field name. So I had a numeric field named "premiumfirstdollarpct" and a character field named "premiumfirstdollarcur" and VFP was trying to update the same base table field with each view field.
>We're having a problem with a datatype mismatch error when running a tableupdate on a view that updates 3 tables. The error box comes up with only "ok" and "cancel" buttons instead of the normal ignore, suspend, cancel, and ok buttons.
>
>After the error, the data all seems to be getting updated properly. We've double, triple and quadruple checked all the variables that get sent to the view before the update, and everything seems to match against the view and the underlying tables, so at this point we're a bit baffled as to why this is happening.
>
>Any ideas on how to troubleshoot and fix this issue would be greatly appreciated.
>
>regards,
>
>Jim Erwin
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05