Insert a row in SQL table for SLX and STANDARDID type

• bibiche-04

  SSC Rookie

  Points: 39

  More actions

  February 22, 2013 at 4:38 am

  #274467

  Hi,

  I would like to insert a new row in a SalesLogix table with SQL however it doesn't work because

  

  insert into sysdba.seccode (seccodedesc, seccodetype) values ('test', 1); -> Doesn't work because no SeccodeID.

  And if I try this :

  insert into sysdba.seccode (seccodeid, seccodedesc, seccodetype) values (1, 'test', 1);

  The line has been inserted but I can't find it in my table :

  SELECT * FROM [PDW_SLX].[sysdba].[SECCODE] WHERE seccodeid = 1

  I'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 ?

  Thanks

• laurie-789651

  SSCertifiable

  Points: 7680

  More actions

  February 22, 2013 at 4:57 am

  #1590289

  There's a Sage SalesLogix Forum at:

  community.sagesaleslogix.com/

  They might be your best bet.

• Jason-299789

  SSC-Insane

  Points: 21601

  More actions

  February 22, 2013 at 6:40 am

  #1590323

  The 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

  SELECT * from PDW_SLX.sysdba.SECCODE where SECCODEID='1'

  This will run without a problem.

  _________________________________________________________________________
  SSC Guide to Posting and Best Practices