查询明细帐、总帐提示“实时错误91，null无效”-用友U8

对应版本:用友U8.51对应产品线：财务系统对应模块：总账模块问题现象:在总帐中，有时会发生查询明细帐、总帐提示“实时错误91，null无效”问题原因：1、发现用户辅助总帐、总帐表单中金额、数量、外币字段属性被设置为容许为空，（导致数据行中有许多null值）2、默认绑定不存在。解决方案：UPDATEGL_accsumSETmb=0,md=0,mc=0,me=0,mb_f=0,md_f=0,mc_f=0,me_f=0,nb_s=0,nd_s=0,nc_s=0,ne_s=0WHERE(mbISNULL)OR(mdISNULL)OR(mcISNULL)OR(meISNULL)OR(mb_fISNULL)OR(md_fISNULL)OR(mc_fISNULL)OR(me_fISNULL)OR(nb_sISNULL)OR(nd_sISNULL)OR(nc_sISNULL)OR(ne_sISNULL)UPDATEGL_accassSETmb=0,md=0,mc=0,me=0,mb_f=0,md_f=0,mc_f=0,me_f=0,nb_s=0,nd_s=0,nc_s=0,ne_s=0WHERE(mbISNULL)OR(mdISNULL)OR(mcISNULL)OR(meISNULL)OR(mb_fISNULL)OR(md_fISNULL)OR(mc_fISNULL)OR(me_fISNULL)OR(nb_sISNULL)OR(nd_sISNULL)OR(nc_sISNULL)OR(ne_sISNULL)--删除、建立、绑定默认值ifexists(select*fromdbo.sysobjectswhereid=object_id(N’[dbo].[GL_accass_mb_f_D]’)andOBJECTPROPERTY(id,N’IsDefault’)=1)dropdefault[dbo].[GL_accass_mb_f_D]GOifexists(select*fromdbo.sysobjectswhereid=object_id(N’[dbo].[GL_accass_mc_D]’)andOBJECTPROPERTY(id,N’IsDefault’)=1)dropdefault[dbo].[GL_accass_mc_D]GOifexists(select*fromdbo.sysobjectswhereid=object_id(N’[dbo].[GL_accass_mc_f_D]’)andOBJECTPROPERTY(id,N’IsDefault’)=1)dropdefault[dbo].[GL_accass_mc_f_D]GOifexists(select*fromdbo.sysobjectswhereid=object_id(N’[dbo].[GL_accass_md_D]’)andOBJECTPROPERTY(id,N’IsDefault’)=1)dropdefault[dbo].[GL_accass_md_D]GOifexists(select*fromdbo.sysobjectswhereid=object_id(N’[dbo].[GL_accass_md_f_D]’)andOBJECTPROPERTY(id,N’IsDefault’)=1)dropdefault[dbo].[GL_accass_md_f_D]GOifexists(select*fromdbo.sysobjectswhereid=object_id(N’[dbo].[GL_accass_me_D]’)andOBJECTPROPERTY(id,N’IsDefault’)=1)dropdefault[dbo].[GL_accass_me_D]GOifexists(select*fromdbo.sysobjectswhereid=object_id(N’[dbo].[GL_accass_me_f_D]’)andOBJECTPROPERTY(id,N’IsDefault’)=1)dropdefault[dbo].[GL_accass_me_f_D]GOifexists(select*fromdbo.sysobjectswhereid=object_id(N’[dbo].[GL_accass_nb_s_D]’)andOBJECTPROPERTY(id,N’IsDefault’)=1)dropdefault[dbo].[GL_accass_nb_s_D]GOifexists(select*fromdbo.sysobjectswhereid=object_id(N’[dbo].[GL_accass_nc_s_D]’)andOBJECTPROPERTY(id,N’IsDefault’)=1)dropdefault[dbo].[GL_accass_nc_s_D]GOifexists(select*fromdbo.sysobjectswhereid=object_id(N’[dbo].[GL_accass_nd_s_D]’)andOBJECTPROPERTY(id,N’IsDefault’)=1)dropdefault[dbo].[GL_accass_nd_s_D]GOifexists(select*fromdbo.sysobjectswhereid=object_id(N’[dbo].[GL_accass_ne_s_D]’)andOBJECTPROPERTY(id,N’IsDefault’)=1)dropdefault[dbo].[GL_accass_ne_s_D]GOifexists(select*fromdbo.sysobjectswhereid=object_id(N’[dbo].[GL_accass_mb_D]’)andOBJECTPROPERTY(id,N’IsDefault’)=1)dropdefault[dbo].[GL_accass_mb_D]GOifexists(select*fromdbo.sysobjectswhereid=object_id(N’[dbo].[GL_accsum_mb_D]’)andOBJECTPROPERTY(id,N’IsDefault’)=1)dropdefault[dbo].[GL_accsum_mb_D]GOifexists(select*fromdbo.sysobjectswhereid=object_id(N’[dbo].[GL_accsum_mb_f_D]’)andOBJECTPROPERTY(id,N’IsDefault’)=1)dropdefault[dbo].[GL_accsum_mb_f_D]GOifexists(select*fromdbo.sysobjectswhereid=object_id(N’[dbo].[GL_accsum_mc_D]’)andOBJECTPROPERTY(id,N’IsDefault’)=1)dropdefault[dbo].[GL_accsum_mc_D]GOifexists(select*fromdbo.sysobjectswhereid=object_id(N’[dbo].[GL_accsum_mc_f_D]’)andOBJECTPROPERTY(id,N’IsDefault’)=1)dropdefault[dbo].[GL_accsum_mc_f_D]GOifexists(select*fromdbo.sysobjectswhereid=object_id(N’[dbo].[GL_accsum_md_D]’)andOBJECTPROPERTY(id,N’IsDefault’)=1)dropdefault[dbo].[GL_accsum_md_D]GOifexists(select*fromdbo.sysobjectswhereid=object_id(N’[dbo].[GL_accsum_md_f_D]’)andOBJECTPROPERTY(id,N’IsDefault’)=1)dropdefault[dbo].[GL_accsum_md_f_D]GOifexists(select*fromdbo.sysobjectswhereid=object_id(N’[dbo].[GL_accsum_me_D]’)andOBJECTPROPERTY(id,N’IsDefault’)=1)dropdefault[dbo].[GL_accsum_me_D]GOifexists(select*fromdbo.sysobjectswhereid=object_id(N’[dbo].[GL_accsum_me_f_D]’)andOBJECTPROPERTY(id,N’IsDefault’)=1)dropdefault[dbo].[GL_accsum_me_f_D]GOifexists(select*fromdbo.sysobjectswhereid=object_id(N’[dbo].[GL_accsum_nb_s_D]’)andOBJECTPROPERTY(id,N’IsDefault’)=1)dropdefault[dbo].[GL_accsum_nb_s_D]GOifexists(select*fromdbo.sysobjectswhereid=object_id(N’[dbo].[GL_accsum_nc_s_D]’)andOBJECTPROPERTY(id,N’IsDefault’)=1)dropdefault[dbo].[GL_accsum_nc_s_D]GOifexists(select*fromdbo.sysobjectswhereid=object_id(N’[dbo].[GL_accsum_nd_s_D]’)andOBJECTPROPERTY(id,N’IsDefault’)=1)dropdefault[dbo].[GL_accsum_nd_s_D]GOifexists(select*fromdbo.sysobjectswhereid=object_id(N’[dbo].[GL_accsum_ne_s_D]’)andOBJECTPROPERTY(id,N’IsDefault’)=1)dropdefault[dbo].[GL_accsum_ne_s_D]GOCREATEDEFAULTdbo.GL_accass_mb_f_DAS0GOCREATEDEFAULTdbo.GL_accass_mc_DAS0GOCREATEDEFAULTdbo.GL_accass_mc_f_DAS0GOCREATEDEFAULTdbo.GL_accass_md_DAS0GOCREATEDEFAULTdbo.GL_accass_md_f_DAS0GOCREATEDEFAULTdbo.GL_accass_me_DAS0GOCREATEDEFAULTdbo.GL_accass_me_f_DAS0GOCREATEDEFAULTdbo.GL_accass_nb_s_DAS0GOCREATEDEFAULTdbo.GL_accass_nc_s_DAS0GOCREATEDEFAULTdbo.GL_accass_nd_s_DAS0GOCREATEDEFAULTdbo.GL_accass_ne_s_DAS0GOCREATEDEFAULTdbo.GL_accass_mb_DAS0GOCREATEDEFAULTdbo.GL_accsum_mb_DAS0GOCREATEDEFAULTdbo.GL_accsum_mb_f_DAS0GOCREATEDEFAULTdbo.GL_accsum_mc_DAS0GOCREATEDEFAULTdbo.GL_accsum_mc_f_DAS0GOCREATEDEFAULTdbo.GL_accsum_md_DAS0GOCREATEDEFAULTdbo.GL_accsum_md_f_DAS0GOCREATEDEFAULTdbo.GL_accsum_me_DAS0GOCREATEDEFAULTdbo.GL_accsum_me_f_DAS0GOCREATEDEFAULTdbo.GL_accsum_nb_s_DAS0GOCREATEDEFAULTdbo.GL_accsum_nc_s_DAS0GOCREATEDEFAULTdbo.GL_accsum_nd_s_DAS0GOCREATEDEFAULTdbo.GL_accsum_ne_s_DAS0GOEXECsp_bindefaultN’[dbo].[GL_accass_mb_D]’,N’[GL_accass].[mb]’GOEXECsp_bindefaultN’[dbo].[GL_accass_mb_f_D]’,N’[GL_accass].[mb_f]’GOEXECsp_bindefaultN’[dbo].[GL_accass_mc_D]’,N’[GL_accass].[mc]’GOEXECsp_bindefaultN’[dbo].[GL_accass_mc_f_D]’,N’[GL_accass].[mc_f]’GOEXECsp_bindefaultN’[dbo].[GL_accass_md_D]’,N’[GL_accass].[md]’GOEXECsp_bindefaultN’[dbo].[GL_accass_md_f_D]’,N’[GL_accass].[md_f]’GOEXECsp_bindefaultN’[dbo].[GL_accass_me_D]’,N’[GL_accass].[me]’GOEXECsp_bindefaultN’[dbo].[GL_accass_me_f_D]’,N’[GL_accass].[me_f]’GOEXECsp_bindefaultN’[dbo].[GL_accass_nb_s_D]’,N’[GL_accass].[nb_s]’GOEXECsp_bindefaultN’[dbo].[GL_accass_nc_s_D]’,N’[GL_accass].[nc_s]’GOEXECsp_bindefaultN’[dbo].[GL_accass_nd_s_D]’,N’[GL_accass].[nd_s]’GOEXECsp_bindefaultN’[dbo].[GL_accass_ne_s_D]’,N’[GL_accass].[ne_s]’GOEXECsp_bindefaultN’[dbo].[GL_accsum_mb_D]’,N’[GL_accsum].[mb]’GOEXECsp_bindefaultN’[dbo].[GL_accsum_mb_f_D]’,N’[GL_accsum].[mb_f]’GOEXECsp_bindefaultN’[dbo].[GL_accsum_mc_D]’,N’[GL_accsum].[mc]’GOEXECsp_bindefaultN’[dbo].[GL_accsum_mc_f_D]’,N’[GL_accsum].[mc_f]’GOEXECsp_bindefaultN’[dbo].[GL_accsum_md_D]’,N’[GL_accsum].[md]’GOEXECsp_bindefaultN’[dbo].[GL_accsum_md_f_D]’,N’[GL_accsum].[md_f]’GOEXECsp_bindefaultN’[dbo].[GL_accsum_me_D]’,N’[GL_accsum].[me]’GOEXECsp_bindefaultN’[dbo].[GL_accsum_me_f_D]’,N’[GL_accsum].[me_f]’GOEXECsp_bindefaultN’[dbo].[GL_accsum_nb_s_D]’,N’[GL_accsum].[nb_s]’GOEXECsp_bindefaultN’[dbo].[GL_accsum_nc_s_D]’,N’[GL_accsum].[nc_s]’GOEXECsp_bindefaultN’[dbo].[GL_accsum_nd_s_D]’,N’[GL_accsum].[nd_s]’GOEXECsp_bindefaultN’[dbo].[GL_accsum_ne_s_D]’,N’[GL_accsum].[ne_s]’GO--更新总帐、辅助总帐表单结构ALTERTABLEGL_accsumALTERCOLUMN

本文链接：http://www.bbsufida.com/u8/39359.html