Insert a row in SQL table for SLX and STANDARDID type

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Insert a row in SQL table for SLX and...

Insert a row in SQL table for SLX and STANDARDID type

Rate Topic

Display Mode

Topic Options

Author

Message

bibiche-04

Posted Friday, February 22, 2013 4:38 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, June 06, 2013 1:20 AM
Points: 1, Visits: 11

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

Post #1422981

laurie-789651

Posted Friday, February 22, 2013 4:57 AM

SSC Veteran

Group: General Forum Members
Last Login: Thursday, May 30, 2013 1:26 PM
Points: 278, Visits: 808

There's a Sage SalesLogix Forum at:

community.sagesaleslogix.com/

They might be your best bet.

Post #1422986

Jason-299789

Posted Friday, February 22, 2013 6:40 AM

SSC Eights!

Group: General Forum Members
Last Login: Today @ 10:57 AM
Points: 838, Visits: 2,200

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

Post #1423023

« Prev Topic | Next Topic »

Permissions