|
马上注册,结交更多好友,享用更多功能,让你轻松玩转社区。
您需要 登录 才可以下载或查看,没有账号?注册账号
×
数据库名: UFDATA_005_2011
D:\U8SOFT\Admin\SQLFILE8700\Main\Ufdata\data\NL\Data_Data_GL_mix_NL.sql
错误信息:
-2147217900
列名 'cDirection' 无效。
执行如下语句时出错:
--恢复记帐菜单的隐藏处理
insert into accinformation(cSysID,cID,cName,cCaption,cType,cValue) values('GL','120','cGLJZ','恢复记账','Text','0')
insert into accinformation(cSysID,cID,cName,cCaption,cType,cValue) values('GF','120','cGFJZ','恢复记账','Text','0')
if Not (exists(select citem_class from GL_AccVouch Where citem_class = '98' And cItem_id Is Not NULL) Or exists(select Top 1 * from GL_CashTable) Or exists(select citem_class from GL_AccAss Where citem_class = '98' And cItem_id Is Not NULL))
Begin
Delete From fitemss98
if exists(select cItemCcode from fitemss98class Where cItemCcode = '0101' And bItemCend = 1)
Begin
INSERT INTO fitemss98(citemcode, citemname, bclose, citemccode, iotherused, cDirection)
VALUES('01', '销售商品、提供劳务收到的现金', 0, '0101', NULL,'流入')
INSERT INTO fitemss98(citemcode, citemname, bclose, citemccode, iotherused, cDirection)
VALUES('02', '收到的税费返还', 0, '0101', NULL,'流入')
INSERT INTO fitemss98(citemcode, citemname, bclose, citemccode, iotherused, cDirection)
VALUES('03', '收到的其他与经营活动的现金', 0, '0101', NULL,'流入')
End
请求高手解救一下菜鸟的我!
|
|