Can LLBLGen Pro handle INSERTS, UPDATES, and DELETES on Partitioned Views (PV) in SQL Server 2000/2005. Keep in mind that I am specifically referring to "Partitioned Views", and not "Partitioned Tables" available only in SQL 2005 EE, DE.

The INSERT and UPDATE statements on PVs have certain requirements. For example, all columns must be explicitly stated in INSERT statements, even columns that allow NULLs and columns that have default values.

I suppose this issue could be circumvented by the developer making sure to explicitly write all column-value pairs prior to calling the save() method of the DataAccessAdapter, but I just wanted to make sure.

Thanks,

Mike

ARITHABORT has to be switched on (check this) and indeed you have to make sure all fields have a value set.