将截断字符串或二进制数据“
问题:入职、离职、调动、转正单据提交生效报错: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:
解决方法:执行下面三条语句
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:
将截断字符串或二进制数据“
问题:入职、离职、调动、转正单据提交生效报错:update data error.String or binary data would be truncated.DataLimit 或者“...
点击下载文档
本文2024-09-16 23:50:50发表“s-hr cloud知识”栏目。
本文链接:https://wenku.my7c.com/article/kingdee-shr-57182.html
您需要登录后才可以发表评论, 登录登录 或者 注册
最新文档
热门文章