Le Forum des Utilisateurs Sage

de **kervb** » Ven 21 Oct 2011 14:52

Hello,

I have a software which create sales document automatically in Sage Trading by writing directly in the SQL Server database. While running the module which carried out this process I have got the following error message:
"[Microsoft][ODBC SQL Server Driver][SQL Server] violation of UNIQUE KEY constraint 'IDL_NO'. Cannot insert duplicate key in object 'F_DOCLIGNE' "

Can you please help?

Thanks.

de **Recce007** » Mar 1 Nov 2011 11:42

Hello,
Could you be more explicit about your environment?
Are you using Sage ODBC to push data in Sage DB? In this case, you insert command should allocate 0 to DL_No (the system will store the correct value itself).

Rgds,

Le Forum des Utilisateurs Sage

Error on insert in table F_DOCLIGNE

Error on insert in table F_DOCLIGNE

Re: Error on insert in table F_DOCLIGNE

Qui est en ligne