I would like to insert a new row in a SalesLogix table with SQL however it doesn't work becauseinsert 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 ?