反过账数据库语句
盛钧吉
1407次浏览
编辑于2016年07月15日 14:57:51
为什么金蝶专业版中在数据库中输入反过账的语句执行不了
DELETE FROM t_SystemProfile WHERE FKey='unPosKey'
INSERT INTO t_SystemProfile (FCategory, FKey, FValue, FReadonly, FDescription, FLevel, FExplanation, FFormat, FSort, FDescription_cht, FDescription_en)
VALUES ('General', 'unPosKey', '1', 0, '', ' ', ' ', '', 1, '', '')
GO
UPDATE t_objectaccesstype SET FObjectID=0 WHERE FObjectType=4 AND FObjectID=-1 AND fname='反过账'
GO
而在账套管理中输入相同的代码却能执行
DELETE FROM t_SystemProfile WHERE FKey='unPosKey'
INSERT INTO t_SystemProfile (FCategory, FKey, FValue, FReadonly, FDescription, FLevel, FExplanation, FFormat, FSort, FDescription_cht, FDescription_en)
VALUES ('General', 'unPosKey', '1', 0, '', ' ', ' ', '', 1, '', '')
GO
UPDATE t_objectaccesstype SET FObjectID=0 WHERE FObjectType=4 AND FObjectID=-1 AND fname='反过账'
GO
而在账套管理中输入相同的代码却能执行
推荐阅读