Thursday 2 July 2015

The INSERT statement conflicted with the CHECK constraint

ISSUE:

         Microsoft.Dynamics.GP.eConnect.eConnectException: The INSERT statement conflicted with the CHECK constraint "CK__POP10100__CREATD__0618D7E0". The conflict occurred in database "TWO", table "POP10100", column 'DOCDATE'.
The statement has been terminated.


SOLUTION:

                   
                    You have to declare date field in below format.

                    DOCDATE = DateTime.Now.Date.ToString();

No comments:

Post a Comment