>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?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.