I can't think of anything off the top of my head. I don't have much experience with SQL Server but the fact that the view works with VFP says it has to do with some attribute of SQL Server.
>Hi Tom,
>
>>Check the FIELD properties in the view, sometime they get messed up and you'll have a long where you need an integer, etc.
>
>Thanks for the suggestion. I have verified that as well. I just double-checked to be sure.
>
>The help on error 1547 is what confuses me:
>"While a view is updating, a new empty record (with no modified fields) is being inserted into one of the base tables of the view.
>
>Make sure each record inserted from a view into a base table has at least one field that has been modified in the view prior to the view update."
>
>I checked GetFldStat(-1) and got a string of 3's and 4's. I even went through and changed each field so that the string was all 4's. Same error.
>
>Any ideas??
-TomC