Insert a row in SQL table for SLX and STANDARDID type

  • 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

  • There's a Sage SalesLogix Forum at:

    community.sagesaleslogix.com/

    They might be your best bet.

  • 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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply