>>Good point. I look into this. Still doesn't make sense why that would fail but the INSERT INTO for each records doesn't. It said ID cannot be null..well, there are no NULL ID's in my VFP table! A bit strange.
>>
>>Thnnk you!
>>- GM
>
>The NULL value error may be coming from SQL Server. It may be saying that you have not supplied a value for that column and it cannot be null. Make sure that the ID column is updateable (If it is a key field of the SQL Server primary key, by default the view marks these fields as not updateable. Make sure that all the fields of your view are updateable)
Thanks a lot for the tip... it seems SQL Server thinks empty string are the same as NULL...this could be the problem!!