>>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.
>>
>>Can someone see what I'm doing wrong here?
>>
>>TIA,
>
>
>VFP right?
>Why here. Anyway, Are you sure that order in cFieldList is exactly as fields are ordered in cTable?
cTable is VFP and cView is a remote view of a SQL Server database. cFieldList was created from an array created by AFIELDS(). And the table was created by a SQLEXEC() against a duplicate SQL Server database that I'm using for a source. The VFP database is an interim step to do some data hygeine before loading the data into the target SQL Server database.
Does that explain it?
Jim