InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 15:57:10 GMT20http://www.sqlservercentral.com/Forums/Topic1422981-391-1.aspxThe database is running user defined data type, so the selct you are running is attempting to convert the SECCODEID(varchar) to an INT, data type. If you did [code="sql"]SELECT * from PDW_SLX.sysdba.SECCODE where SECCODEID='1'[/code]This will run without a problem.Fri, 22 Feb 2013 06:40:15 GMTJason-299789http://www.sqlservercentral.com/Forums/Topic1422981-391-1.aspxThere's a Sage SalesLogix Forum at:[url]community.sagesaleslogix.com/[/url]They might be your best bet.Fri, 22 Feb 2013 04:57:48 GMTlaurie-789651http://www.sqlservercentral.com/Forums/Topic1422981-391-1.aspxHi,I would like to insert a new row in a SalesLogix table with SQL however it doesn't work because[img]https://lh6.googleusercontent.com/-XFpco1Rdw5g/USdW_U3JOdI/AAAAAAAAAMo/EpoHel0CGys/s443/2013-02-22_12h29_32.png[/img][i]insert into sysdba.seccode (seccodedesc, seccodetype) values ('test', 1); -> Doesn't work because no SeccodeID.[/i]And if I try this : [i]insert into sysdba.seccode (seccodeid, seccodedesc, seccodetype) values (1, 'test', 1);[/i]The line has been inserted but I can't find it in my table :SELECT * FROM [PDW_SLX].[sysdba].[SECCODE] WHERE seccodeid = 1I've got the error (translate FR->EN) : Can't cast/convert varchar value 'N6UJ9A00009' in int data type.Does anybody know how I can do?What is STANDARDID datatype ?ThanksFri, 22 Feb 2013 04:38:05 GMTbibiche-04