Error on insert in table F_DOCLIGNE

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.

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,

Hi evryone i have the same problem ,this is my command ,i set DL_NO =0 but i still get the same error

insert into F_DOCLIGNE (DO_DOMAINE ,DO_TYPE ,DE_NO ,DL_NO,dl_ligne ,dl_trempied ,DL_TRemExep,DL_QteBC ,DL_QteBL,
DL_PoidsNet,DL_PoidsBrut,DL_Remise01REM_Type,EU_Qte,DL_TTC,DL_Valorise,EU_Enumere,
DL_Qte,DO_PIECE,AR_REF,DL_PrixUnitaire,dl_taxe1,DL_MontantHT,DL_MontantTTC)
select 0,6,0,0,0,0,0,1,1,0,0,0,1,0,1,'Pièce',1,[FCL INV],Article,prix,TAXE,prix,(prix+(prix*(TAXE/100)))
FROM LIGNES$