>Is
own_Owner_Code field marked in the view as updatable?
>
>>I'm getting the following error message, "Connectivity error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'own_OWNER_CODE', table 'InOrder_Live.dbo.tblCustomerType'; column does not allow nulls. INSERT fails." from the following line of code.
>>
>>INSERT INTO (cView) (&cFieldList) SELECT * FROM (cTable)
>>
>>I've checked the cFieldList value in the Trace window and it includes the own_Owner_Code field. I've verified that the field in the source, cTable, doesn't include any blank or null values.
>>
Thanks Sergey, that was it. But, correcting that and running it again, I get the following error, "Connectivity error: [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint 'XPKtblCustomerType'. Cannot insert duplicate key in object 'tblCustomerType'."
The SQL table has 2 fields marked as PK, own_Owner_Code and typ_Customer_Type. I assume that it is a concatenated key because own_Owner_Code is all the same value while typ_Customer_Type uses unique values.
Any more ideas?
Thanks,
Jim