金蝶K3转T3然后升级T+19.0
exec('update UFDATA_003_2023..gl_mend set bflag=0 where iperiod<>0')go
exec('delete from UFDATA_003_2023..gl_accsum')
go
exec('delete from UFDATA_003_2023..gl_accass')
go
exec('delete from UFDATA_003_2023..gl_accvouch')
go
exec('delete from UFDATA_003_2023..ForeignCurrency where cexch_name<>''人民币''')
go
exec('insert into UFDATA_003_2023..ForeignCurrency(cexch_name,cexch_code,bcal,idec,nerror)select FName as cexch_name,FNumber as cexch_code,case FOperator when ''*'' then 1 when ''/'' then 0 end as bcal,FScale as idec,0.00001 as nerror from a..t_Currency where FNumber<>''*'' and FCurrencyID not like (select FValue from a..t_SystemProfile where FDescription like ''本位币'')')
go
使用转换工具提示截断字符
本帖最后由 yuwen007cn 于 2024-3-4 10:15 编辑
金蝶K3转T3,提示截断数据,是某些字段内容过长,比如摘要,不影响数据的
页:
[1]