用友U8 在总帐中,有时会发生查询明细帐、总帐提示“实时错误91,null无效”用友U8 在总帐中,有时会发生查询明细帐、总帐提示“实时错误91,null无效”
问题原因:1、发现用户辅助总帐、总帐表单中金额、数量、外币字段属性被设置为容许为空,(导致数据行中有许多null值)2、默认绑定不存在。 解决方法:UPDATE GL_accsumSET mb = 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 (mb IS NULL) OR (md IS NULL) OR (mc IS NULL) OR (me IS NULL) OR (mb_f IS NULL) OR (md_f IS NULL) OR (mc_f IS NULL) OR (me_f IS NULL) OR (nb_s IS NULL) OR (nd_s IS NULL) OR (nc_s IS NULL) OR (ne_s IS NULL)UPDATE GL_accassSET mb = 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 (mb IS NULL) OR (md IS NULL) OR (mc IS NULL) OR (me IS NULL) OR (mb_f IS NULL) OR (md_f IS NULL) OR (mc_f IS NULL) OR (me_f IS NULL) OR (nb_s IS NULL) OR (nd_s IS NULL) OR (nc_s IS NULL) OR (ne_s IS NULL)--删除、建立、绑定默认值if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GL_accass_mb_f_D]') and OBJECTPROPERTY(id, N'IsDefault') = 1)drop default [dbo].[GL_accass_mb_f_D]GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GL_accass_mc_D]') and OBJECTPROPERTY(id, N'IsDefault') = 1)drop default [dbo].[GL_accass_mc_D]GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GL_accass_mc_f_D]') and OBJECTPROPERTY(id, N'IsDefault') = 1)drop default [dbo].[GL_accass_mc_f_D]GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GL_accass_md_D]') and OBJECTPROPERTY(id, N'IsDefault') = 1)drop default [dbo].[GL_accass_md_D]GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GL_accass_md_f_D]') and OBJECTPROPERTY(id, N'IsDefault') = 1)drop default [dbo].[GL_accass_md_f_D]GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GL_accass_me_D]') and OBJECTPROPERTY(id, N'IsDefault') = 1)drop default [dbo].[GL_accass_me_D]GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GL_accass_me_f_D]') and OBJECTPROPERTY(id, N'IsDefault') = 1)drop default [dbo].[GL_accass_me_f_D]GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GL_accass_nb_s_D]') and OBJECTPROPERTY(id, N'IsDefault') = 1)drop default [dbo].[GL_accass_nb_s_D]GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GL_accass_nc_s_D]') and OBJECTPROPERTY(id, N'IsDefault') = 1)drop default [dbo].[GL_accass_nc_s_D]GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GL_accass_nd_s_D]') and OBJECTPROPERTY(id, N'IsDefault') = 1)drop default [dbo].[GL_accass_nd_s_D]GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GL_accass_ne_s_D]') and OBJECTPROPERTY(id, N'IsDefault') = 1)drop default [dbo].[GL_accass_ne_s_D]GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GL_accass_mb_D]') and OBJECTPROPERTY(id, N'IsDefault') = 1)drop default [dbo].[GL_accass_mb_D]GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GL_accsum_mb_D]') and OBJECTPROPERTY(id, N'IsDefault') = 1)drop default [dbo].[GL_accsum_mb_D]GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GL_accsum_mb_f_D]') and OBJECTPROPERTY(id, N'IsDefault') = 1)drop default [dbo].[GL_accsum_mb_f_D]GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GL_accsum_mc_D]') and OBJECTPROPERTY(id, N'IsDefault') = 1)drop default [dbo].[GL_accsum_mc_D]GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GL_accsum_mc_f_D]') and OBJECTPROPERTY(id, N'IsDefault') = 1)drop default [dbo].[GL_accsum_mc_f_D]GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GL_accsum_md_D]') and OBJECTPROPERTY(id, N'IsDefault') = 1)drop default [dbo].[GL_accsum_md_D]GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GL_accsum_md_f_D]') and OBJECTPROPERTY(id, N'IsDefault') = 1)drop default [dbo].[GL_accsum_md_f_D]GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GL_accsum_me_D]') and OBJECTPROPERTY(id, N'IsDefault') = 1)drop default [dbo].[GL_accsum_me_D]GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GL_accsum_me_f_D]') and OBJECTPROPERTY(id, N'IsDefault') = 1)drop default [dbo].[GL_accsum_me_f_D]GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GL_accsum_nb_s_D]') and OBJECTPROPERTY(id, N'IsDefault') = 1)drop default [dbo].[GL_accsum_nb_s_D]GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GL_accsum_nc_s_D]') and OBJECTPROPERTY(id, N'IsDefault') = 1)drop default [dbo].[GL_accsum_nc_s_D]GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GL_accsum_nd_s_D]') and OBJECTPROPERTY(id, N'IsDefault') = 1)drop default [dbo].[GL_accsum_nd_s_D]GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GL_accsum_ne_s_D]') and OBJECTPROPERTY(id, N'IsDefault') = 1)drop default [dbo].[GL_accsum_ne_s_D]GOCREATE DEFAULT dbo.GL_accass_mb_f_D AS 0GOCREATE DEFAULT dbo.GL_accass_mc_D AS 0GOCREATE DEFAULT dbo.GL_accass_mc_f_D AS 0GOCREATE DEFAULT dbo.GL_accass_md_D AS 0GOCREATE DEFAULT dbo.GL_accass_md_f_D AS 0GOCREATE DEFAULT dbo.GL_accass_me_D AS 0GOCREATE DEFAULT dbo.GL_accass_me_f_D AS 0GOCREATE DEFAULT dbo.GL_accass_nb_s_D AS 0GOCREATE DEFAULT dbo.GL_accass_nc_s_D AS 0GOCREATE DEFAULT dbo.GL_accass_nd_s_D AS 0GOCREATE DEFAULT dbo.GL_accass_ne_s_D AS 0GOCREATE DEFAULT dbo.GL_accass_mb_D AS 0GOCREATE DEFAULT dbo.GL_accsum_mb_D AS 0GOCREATE DEFAULT dbo.GL_accsum_mb_f_D AS 0GOCREATE DEFAULT dbo.GL_accsum_mc_D AS 0GOCREATE DEFAULT dbo.GL_accsum_mc_f_D AS 0GOCREATE DEFAULT dbo.GL_accsum_md_D AS 0GOCREATE DEFAULT dbo.GL_accsum_md_f_D AS 0GOCREATE DEFAULT dbo.GL_accsum_me_D AS 0GOCREATE DEFAULT dbo.GL_accsum_me_f_D AS 0GOCREATE DEFAULT dbo.GL_accsum_nb_s_D AS 0GOCREATE DEFAULT dbo.GL_accsum_nc_s_D AS 0GOCREATE DEFAULT dbo.GL_accsum_nd_s_D AS 0GOCREATE DEFAULT dbo.GL_accsum_ne_s_D AS 0GOEXEC sp_bindefault N'[dbo].[GL_accass_mb_D]', N'[GL_accass].[mb]'GOEXEC sp_bindefault N'[dbo].[GL_accass_mb_f_D]', N'[GL_accass].[mb_f]'GOEXEC sp_bindefault N'[dbo].[GL_accass_mc_D]', N'[GL_accass].[mc]'GOEXEC sp_bindefault N'[dbo].[GL_accass_mc_f_D]', N'[GL_accass].[mc_f]'GOEXEC sp_bindefault N'[dbo].[GL_accass_md_D]', N'[GL_accass].[md]'GOEXEC sp_bindefault N'[dbo].[GL_accass_md_f_D]', N'[GL_accass].[md_f]'GOEXEC sp_bindefault N'[dbo].[GL_accass_me_D]', N'[GL_accass].[me]'GOEXEC sp_bindefault N'[dbo].[GL_accass_me_f_D]', N'[GL_accass].[me_f]'GOEXEC sp_bindefault N'[dbo].[GL_accass_nb_s_D]', N'[GL_accass].[nb_s]'GOEXEC sp_bindefault N'[dbo].[GL_accass_nc_s_D]', N'[GL_accass].[nc_s]'GOEXEC sp_bindefault N'[dbo].[GL_accass_nd_s_D]', N'[GL_accass].[nd_s]'GOEXEC sp_bindefault N'[dbo].[GL_accass_ne_s_D]', N'[GL_accass].[ne_s]'GOEXEC sp_bindefault N'[dbo].[GL_accsum_mb_D]', N'[GL_accsum].[mb]'GOEXEC sp_bindefault N'[dbo].[GL_accsum_mb_f_D]', N'[GL_accsum].[mb_f]'GOEXEC sp_bindefault N'[dbo].[GL_accsum_mc_D]', N'[GL_accsum].[mc]'GOEXEC sp_bindefault N'[dbo].[GL_accsum_mc_f_D]', N'[GL_accsum].[mc_f]'GOEXEC sp_bindefault N'[dbo].[GL_accsum_md_D]', N'[GL_accsum].[md]'GOEXEC sp_bindefault N'[dbo].[GL_accsum_md_f_D]', N'[GL_accsum].[md_f]'GOEXEC sp_bindefault N'[dbo].[GL_accsum_me_D]', N'[GL_accsum].[me]'GOEXEC sp_bindefault N'[dbo].[GL_accsum_me_f_D]', N'[GL_accsum].[me_f]'GOEXEC sp_bindefault N'[dbo].[GL_accsum_nb_s_D]', N'[GL_accsum].[nb_s]'GOEXEC sp_bindefault N'[dbo].[GL_accsum_nc_s_D]', N'[GL_accsum].[nc_s]'GOEXEC sp_bindefault N'[dbo].[GL_accsum_nd_s_D]', N'[GL_accsum].[nd_s]'GOEXEC sp_bindefault N'[dbo].[GL_accsum_ne_s_D]', N'[GL_accsum].[ne_s]'GO--更新总帐、辅助总帐表单结构ALTER TABLE GL_accsum ALTER COLUMN cbegind_c varchar(2) not NULLALTER TABLE GL_accsum ALTER COLUMN cbegind_c_engl varchar(2) not NULLALTER TABLE GL_accsum ALTER COLUMN mb money not NULLALTER TABLE GL_accsum ALTER COLUMN md money not NULLALTER TABLE GL_accsum ALTER COLUMN mc money not NULLALTER TABLE GL_accsum ALTER COLUMN cendd_c varchar(2) not NULLALTER TABLE GL_accsum ALTER COLUMN cendd_c_engl varchar(2) not NULLALTER TABLE GL_accsum ALTER COLUMN me money not NULLALTER TABLE GL_accsum ALTER COLUMN mb_f money not NULLALTER TABLE GL_accsum ALTER COLUMN md_f money not NULLALTER TABLE GL_accsum ALTER COLUMN mc_f money not NULLALTER TABLE GL_accsum ALTER COLUMN me_f money not NULLALTER TABLE GL_accsum ALTER COLUMN nb_s float not NULLALTER TABLE GL_accsum ALTER COLUMN nd_s float not NULLALTER TABLE GL_accsum ALTER COLUMN nc_s float not NULLALTER TABLE GL_accsum ALTER COLUMN ne_s float not NULL--跟新辅助总帐结构ALTER TABLE GL_accass ALTER COLUMN cbegind_c varchar(2) not NULLALTER TABLE GL_accass ALTER COLUMN cbegind_c_engl varchar(2) not NULLALTER TABLE GL_accass ALTER COLUMN mb money not NULLALTER TABLE GL_accass ALTER COLUMN md money not NULLALTER TABLE GL_accass ALTER COLUMN mc money not NULLALTER TABLE GL_accass ALTER COLUMN cendd_c varchar(2) not NULLALTER TABLE GL_accass ALTER COLUMN cendd_c_engl varchar(2) not NULLALTER TABLE GL_accass ALTER COLUMN me money not NULLALTER TABLE GL_accass ALTER COLUMN mb_f money not NULLALTER TABLE GL_accass ALTER COLUMN md_f money not NULLALTER TABLE GL_accass ALTER COLUMN mc_f money not NULLALTER TABLE GL_accass ALTER COLUMN me_f money not NULLALTER TABLE GL_accass ALTER COLUMN nb_s float not NULLALTER TABLE GL_accass ALTER COLUMN nd_s float not NULLALTER TABLE GL_accass ALTER COLUMN nc_s float not NULLALTER TABLE GL_accass ALTER COLUMN ne_s float not NULL
解决方案:
问题原因:1、发现用户辅助总帐、总帐表单中金额、数量、外币字段属性被设置为容许为空,(导致数据行中有许多null值)2、默认绑定不存在。 解决方法:UPDATE GL_accsumSET mb = 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 (mb IS NULL) OR (md IS NULL) OR (mc IS NULL) OR (me IS NULL) OR (mb_f IS NULL) OR (md_f IS NULL) OR (mc_f IS NULL) OR (me_f IS NULL) OR (nb_s IS NULL) OR (nd_s IS NULL) OR (nc_s IS NULL) OR (ne_s IS NULL)UPDATE GL_accassSET mb = 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 (mb IS NULL) OR (md IS NULL) OR (mc IS NULL) OR (me IS NULL) OR (mb_f IS NULL) OR (md_f IS NULL) OR (mc_f IS NULL) OR (me_f IS NULL) OR (nb_s IS NULL) OR (nd_s IS NULL) OR (nc_s IS NULL) OR (ne_s IS NULL)--删除、建立、绑定默认值if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GL_accass_mb_f_D]') and OBJECTPROPERTY(id, N'IsDefault') = 1)drop default [dbo].[GL_accass_mb_f_D]GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GL_accass_mc_D]') and OBJECTPROPERTY(id, N'IsDefault') = 1)drop default [dbo].[GL_accass_mc_D]GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GL_accass_mc_f_D]') and OBJECTPROPERTY(id, N'IsDefault') = 1)drop default [dbo].[GL_accass_mc_f_D]GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GL_accass_md_D]') and OBJECTPROPERTY(id, N'IsDefault') = 1)drop default [dbo].[GL_accass_md_D]GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GL_accass_md_f_D]') and OBJECTPROPERTY(id, N'IsDefault') = 1)drop default [dbo].[GL_accass_md_f_D]GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GL_accass_me_D]') and OBJECTPROPERTY(id, N'IsDefault') = 1)drop default [dbo].[GL_accass_me_D]GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GL_accass_me_f_D]') and OBJECTPROPERTY(id, N'IsDefault') = 1)drop default [dbo].[GL_accass_me_f_D]GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GL_accass_nb_s_D]') and OBJECTPROPERTY(id, N'IsDefault') = 1)drop default [dbo].[GL_accass_nb_s_D]GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GL_accass_nc_s_D]') and OBJECTPROPERTY(id, N'IsDefault') = 1)drop default [dbo].[GL_accass_nc_s_D]GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GL_accass_nd_s_D]') and OBJECTPROPERTY(id, N'IsDefault') = 1)drop default [dbo].[GL_accass_nd_s_D]GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GL_accass_ne_s_D]') and OBJECTPROPERTY(id, N'IsDefault') = 1)drop default [dbo].[GL_accass_ne_s_D]GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GL_accass_mb_D]') and OBJECTPROPERTY(id, N'IsDefault') = 1)drop default [dbo].[GL_accass_mb_D]GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GL_accsum_mb_D]') and OBJECTPROPERTY(id, N'IsDefault') = 1)drop default [dbo].[GL_accsum_mb_D]GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GL_accsum_mb_f_D]') and OBJECTPROPERTY(id, N'IsDefault') = 1)drop default [dbo].[GL_accsum_mb_f_D]GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GL_accsum_mc_D]') and OBJECTPROPERTY(id, N'IsDefault') = 1)drop default [dbo].[GL_accsum_mc_D]GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GL_accsum_mc_f_D]') and OBJECTPROPERTY(id, N'IsDefault') = 1)drop default [dbo].[GL_accsum_mc_f_D]GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GL_accsum_md_D]') and OBJECTPROPERTY(id, N'IsDefault') = 1)drop default [dbo].[GL_accsum_md_D]GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GL_accsum_md_f_D]') and OBJECTPROPERTY(id, N'IsDefault') = 1)drop default [dbo].[GL_accsum_md_f_D]GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GL_accsum_me_D]') and OBJECTPROPERTY(id, N'IsDefault') = 1)drop default [dbo].[GL_accsum_me_D]GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GL_accsum_me_f_D]') and OBJECTPROPERTY(id, N'IsDefault') = 1)drop default [dbo].[GL_accsum_me_f_D]GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GL_accsum_nb_s_D]') and OBJECTPROPERTY(id, N'IsDefault') = 1)drop default [dbo].[GL_accsum_nb_s_D]GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GL_accsum_nc_s_D]') and OBJECTPROPERTY(id, N'IsDefault') = 1)drop default [dbo].[GL_accsum_nc_s_D]GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GL_accsum_nd_s_D]') and OBJECTPROPERTY(id, N'IsDefault') = 1)drop default [dbo].[GL_accsum_nd_s_D]GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GL_accsum_ne_s_D]') and OBJECTPROPERTY(id, N'IsDefault') = 1)drop default [dbo].[GL_accsum_ne_s_D]GOCREATE DEFAULT dbo.GL_accass_mb_f_D AS 0GOCREATE DEFAULT dbo.GL_accass_mc_D AS 0GOCREATE DEFAULT dbo.GL_accass_mc_f_D AS 0GOCREATE DEFAULT dbo.GL_accass_md_D AS 0GOCREATE DEFAULT dbo.GL_accass_md_f_D AS 0GOCREATE DEFAULT dbo.GL_accass_me_D AS 0GOCREATE DEFAULT dbo.GL_accass_me_f_D AS 0GOCREATE DEFAULT dbo.GL_accass_nb_s_D AS 0GOCREATE DEFAULT dbo.GL_accass_nc_s_D AS 0GOCREATE DEFAULT dbo.GL_accass_nd_s_D AS 0GOCREATE DEFAULT dbo.GL_accass_ne_s_D AS 0GOCREATE DEFAULT dbo.GL_accass_mb_D AS 0GOCREATE DEFAULT dbo.GL_accsum_mb_D AS 0GOCREATE DEFAULT dbo.GL_accsum_mb_f_D AS 0GOCREATE DEFAULT dbo.GL_accsum_mc_D AS 0GOCREATE DEFAULT dbo.GL_accsum_mc_f_D AS 0GOCREATE DEFAULT dbo.GL_accsum_md_D AS 0GOCREATE DEFAULT dbo.GL_accsum_md_f_D AS 0GOCREATE DEFAULT dbo.GL_accsum_me_D AS 0GOCREATE DEFAULT dbo.GL_accsum_me_f_D AS 0GOCREATE DEFAULT dbo.GL_accsum_nb_s_D AS 0GOCREATE DEFAULT dbo.GL_accsum_nc_s_D AS 0GOCREATE DEFAULT dbo.GL_accsum_nd_s_D AS 0GOCREATE DEFAULT dbo.GL_accsum_ne_s_D AS 0GOEXEC sp_bindefault N'[dbo].[GL_accass_mb_D]', N'[GL_accass].[mb]'GOEXEC sp_bindefault N'[dbo].[GL_accass_mb_f_D]', N'[GL_accass].[mb_f]'GOEXEC sp_bindefault N'[dbo].[GL_accass_mc_D]', N'[GL_accass].[mc]'GOEXEC sp_bindefault N'[dbo].[GL_accass_mc_f_D]', N'[GL_accass].[mc_f]'GOEXEC sp_bindefault N'[dbo].[GL_accass_md_D]', N'[GL_accass].[md]'GOEXEC sp_bindefault N'[dbo].[GL_accass_md_f_D]', N'[GL_accass].[md_f]'GOEXEC sp_bindefault N'[dbo].[GL_accass_me_D]', N'[GL_accass].[me]'GOEXEC sp_bindefault N'[dbo].[GL_accass_me_f_D]', N'[GL_accass].[me_f]'GOEXEC sp_bindefault N'[dbo].[GL_accass_nb_s_D]', N'[GL_accass].[nb_s]'GOEXEC sp_bindefault N'[dbo].[GL_accass_nc_s_D]', N'[GL_accass].[nc_s]'GOEXEC sp_bindefault N'[dbo].[GL_accass_nd_s_D]', N'[GL_accass].[nd_s]'GOEXEC sp_bindefault N'[dbo].[GL_accass_ne_s_D]', N'[GL_accass].[ne_s]'GOEXEC sp_bindefault N'[dbo].[GL_accsum_mb_D]', N'[GL_accsum].[mb]'GOEXEC sp_bindefault N'[dbo].[GL_accsum_mb_f_D]', N'[GL_accsum].[mb_f]'GOEXEC sp_bindefault N'[dbo].[GL_accsum_mc_D]', N'[GL_accsum].[mc]'GOEXEC sp_bindefault N'[dbo].[GL_accsum_mc_f_D]', N'[GL_accsum].[mc_f]'GOEXEC sp_bindefault N'[dbo].[GL_accsum_md_D]', N'[GL_accsum].[md]'GOEXEC sp_bindefault N'[dbo].[GL_accsum_md_f_D]', N'[GL_accsum].[md_f]'GOEXEC sp_bindefault N'[dbo].[GL_accsum_me_D]', N'[GL_accsum].[me]'GOEXEC sp_bindefault N'[dbo].[GL_accsum_me_f_D]', N'[GL_accsum].[me_f]'GOEXEC sp_bindefault N'[dbo].[GL_accsum_nb_s_D]', N'[GL_accsum].[nb_s]'GOEXEC sp_bindefault N'[dbo].[GL_accsum_nc_s_D]', N'[GL_accsum].[nc_s]'GOEXEC sp_bindefault N'[dbo].[GL_accsum_nd_s_D]', N'[GL_accsum].[nd_s]'GOEXEC sp_bindefault N'[dbo].[GL_accsum_ne_s_D]', N'[GL_accsum].[ne_s]'GO--更新总帐、辅助总帐表单结构ALTER TABLE GL_accsum ALTER COLUMN cbegind_c varchar(2) not NULLALTER TABLE GL_accsum ALTER COLUMN cbegind_c_engl varchar(2) not NULLALTER TABLE GL_accsum ALTER COLUMN mb money not NULLALTER TABLE GL_accsum ALTER COLUMN md money not NULLALTER TABLE GL_accsum ALTER COLUMN mc money not NULLALTER TABLE GL_accsum ALTER COLUMN cendd_c varchar(2) not NULLALTER TABLE GL_accsum ALTER COLUMN cendd_c_engl varchar(2) not NULLALTER TABLE GL_accsum ALTER COLUMN me money not NULLALTER TABLE GL_accsum ALTER COLUMN mb_f money not NULLALTER TABLE GL_accsum ALTER COLUMN md_f money not NULLALTER TABLE GL_accsum ALTER COLUMN mc_f money not NULLALTER TABLE GL_accsum ALTER COLUMN me_f money not NULLALTER TABLE GL_accsum ALTER COLUMN nb_s float not NULLALTER TABLE GL_accsum ALTER COLUMN nd_s float not NULLALTER TABLE GL_accsum ALTER COLUMN nc_s float not NULLALTER TABLE GL_accsum ALTER COLUMN ne_s float not NULL--跟新辅助总帐结构ALTER TABLE GL_accass ALTER COLUMN cbegind_c varchar(2) not NULLALTER TABLE GL_accass ALTER COLUMN cbegind_c_engl varchar(2) not NULLALTER TABLE GL_accass ALTER COLUMN mb money not NULLALTER TABLE GL_accass ALTER COLUMN md money not NULLALTER TABLE GL_accass ALTER COLUMN mc money not NULLALTER TABLE GL_accass ALTER COLUMN cendd_c varchar(2) not NULLALTER TABLE GL_accass ALTER COLUMN cendd_c_engl varchar(2) not NULLALTER TABLE GL_accass ALTER COLUMN me money not NULLALTER TABLE GL_accass ALTER COLUMN mb_f money not NULLALTER TABLE GL_accass ALTER COLUMN md_f money not NULLALTER TABLE GL_accass ALTER COLUMN mc_f money not NULLALTER TABLE GL_accass ALTER COLUMN me_f money not NULLALTER TABLE GL_accass ALTER COLUMN nb_s float not NULLALTER TABLE GL_accass ALTER COLUMN nd_s float not NULLALTER TABLE GL_accass ALTER COLUMN nc_s float not NULLALTER TABLE GL_accass ALTER COLUMN ne_s float not NULL
www.kuaiji66.com 天龙瑞德