Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Insert a row in SQL table for SLX and STANDARDID type Expand / Collapse
Author
Message
Posted Friday, February 22, 2013 4:38 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, March 5, 2014 1:55 AM
Points: 1, Visits: 15
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
Posted Friday, February 22, 2013 4:57 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, June 27, 2014 8:03 AM
Points: 317, Visits: 1,079
There's a Sage SalesLogix Forum at:

community.sagesaleslogix.com/


They might be your best bet.
Post #1422986
Posted Friday, February 22, 2013 6:40 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 3:19 AM
Points: 884, Visits: 2,415
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 »

Add to briefcase

Permissions Expand / Collapse