将截断字符串或二进制数据“

栏目：s-hr cloud知识作者：金蝶来源：金蝶云社区发布：2024-09-16浏览：1

将截断字符串或二进制数据“

问题：入职、离职、调动、转正单据提交生效报错：update data error.String or binary data would be truncated.DataLimit 或者“将截断字符串或二进制数据“

解决方法：执行下面三条语句
update t_hr_empflowinout set fremark='';
If exists (select * from KSQL_USERCOLUMNS where KSQL_COL_NAME ='FRemark' and KSQL_COL_TABNAME='T_HR_EMPFLOWINOUT') ALTER TABLE T_HR_EMPFLOWINOUT ALTER COLUMN FRemark NVARCHAR(2000);
If exists (select * from KSQL_USERCOLUMNS where KSQL_COL_NAME ='FRemark' and KSQL_COL_TABNAME='T_HR_EmpOrgRelation') ALTER TABLE T_HR_EmpOrgRelation ALTER COLUMN FRemark NVARCHAR(2000);
:/victory: