写个导表的脚本吧:
use ufdata_001_2008
delete VoucherItems
delete VoucherItems_Prn
go
insert into ufdata_001_2008..VoucherItems
(AutoId, VT_ID, CardNum, CardItemNum, CardItemName, CanNotSelect, ShowIt, LinkIt, LinkTbl, LinkField, TableName, FieldName, FieldType, ReferType, ReferTable, CardSection, CardFormula1, CardFormula2, CanModify, MaxLength, MaxShowLen, NumPoint, IsNull, CanDelete, UserCheck, UserPrompt, FormatChar, IsMain, NeedSum, CalcField, AliasNum, isSelfDef, COX, COY, Width, Height, TabIndex, DefaultValue, IsFixedLenght, FormatData, FontState, PrintCaption, PrintUpcase, PrintInterval, DataSource, EnterType, DataRule, ValidityCheck, ReserveSegTitlePos, BuildArchives, ReferReturnField, cmemo, nBorder, pubufts)
select AutoId, VT_ID, CardNum, CardItemNum, CardItemName, CanNotSelect, ShowIt, LinkIt, LinkTbl, LinkField, TableName, FieldName, FieldType, ReferType, ReferTable, CardSection, CardFormula1, CardFormula2, CanModify, MaxLength, MaxShowLen, NumPoint, IsNull, CanDelete, UserCheck, UserPrompt, FormatChar, IsMain, NeedSum, CalcField, AliasNum, isSelfDef, COX, COY, Width, Height, TabIndex, DefaultValue, IsFixedLenght, FormatData, FontState, PrintCaption, PrintUpcase, PrintInterval, DataSource, EnterType, DataRule, ValidityCheck, ReserveSegTitlePos, BuildArchives, ReferReturnField, cmemo, nBorder, pubufts
from ufdata_777_2008..VoucherItems
go
insert into ufdata_001_2008..VoucherItems_Prn
(AutoId, VT_ID, CardNum, CardItemNum, CardItemName, CanNotSelect, ShowIt, LinkIt, LinkTbl, LinkField, TableName, FieldName, FieldType, ReferType, ReferTable, CardSection, CardFormula1, CardFormula2, CanModify, MaxLength, MaxShowLen, NumPoint, IsNull, CanDelete, UserCheck, UserPrompt, FormatChar, IsMain, NeedSum, CalcField, AliasNum, isSelfDef, COX, COY, Width, Height, TabIndex, DefaultValue, IsFixedLenght, FormatData, FontState, PrintCaption, PrintUpcase, PrintInterval, DataSource, EnterType, DataRule, ValidityCheck, ReserveSegTitlePos, BuildArchives, nBorder, ReferReturnField, cmemo, pubufts)
select AutoId, VT_ID, CardNum, CardItemNum, CardItemName, CanNotSelect, ShowIt, LinkIt, LinkTbl, LinkField, TableName, FieldName, FieldType, ReferType, ReferTable, CardSection, CardFormula1, CardFormula2, CanModify, MaxLength, MaxShowLen, NumPoint, IsNull, CanDelete, UserCheck, UserPrompt, FormatChar, IsMain, NeedSum, CalcField, AliasNum, isSelfDef, COX, COY, Width, Height, TabIndex, DefaultValue, IsFixedLenght, FormatData, FontState, PrintCaption, PrintUpcase, PrintInterval, DataSource, EnterType, DataRule, ValidityCheck, ReserveSegTitlePos, BuildArchives, nBorder, ReferReturnField, cmemo, pubufts
form ufdata_777_2008..VoucherItems_Prn
go
先在另个测试帐套上做测试吧。
另如果数据都在同一台服务器上,那么UA_HoldAuth是的处理方法如下:
use ufsystem
delete UA_HoldAuth where cacc_id='001'
然后打开UA_HoldAuth这张表,找到测试帐的权限:select * from UA_HoldAuth where cacc_id='777',将查到的记录复制,然后粘贴到execl表上,在execl表上将cacc_id字段上的777修改为001,改后再把execl里的记录复制,粘贴到UA_HoldAuth表里。
注:此处的001是指正式帐,777是指测试帐。
再注:如果这样都看不懂,我放弃指导。
[ 本帖最后由 R.R 于 2008-8-14 10:35 编辑 ] |