Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Connectivity error
Message
 
 
À
08/02/2006 13:01:06
Jim Winter
Jim Winter Consulting
Hinesburg, Vermont, États-Unis
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Import/Export
Divers
Thread ID:
01094703
Message ID:
01094707
Vues:
14
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.
>
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform