新增凭证保存时提示:凭证保存时报错从数据类型 nvarchar 转换为 bigint 时出错
原因:附件表存储了错误数据
查询语句:
select * from T_BAS_ATTACHMENT where FCREATETIME>='2023-08-30' and fbilltype='gl_voucher'
删除附件:
delete T_BAS_ATTACHMENT where FCREATETIME>='2023-08-30' and fbilltype='gl_voucher'
新增凭证保存时提示:凭证保存时报错从数据类型 nvarchar 转换为 bigint 时出错
原因:附件表存储了错误数据
查询语句:
select * from T_BAS_ATTACHMENT where FCREATETIME>='2023-08-30' and fbilltype='gl_voucher'
删除附件:
delete T_BAS_ATTACHMENT where FCREATETIME>='2023-08-30' and fbilltype='gl_voucher'
推荐阅读