1.清除本地数据 ls_sql1 = "TRUNCATE TABLE" + ls_table [1] execute IMMEDIATE :ls_sql1 using sqlca; 2.//打开可以插入自增,显示插入自增字段的值
ls_sql1 = "SET IDENTITY_INSERT " + ls_table [1] + " on" execute IMMEDIATE :ls_sql1 using sqlca; 3.构造数据窗口,或datastore 4.wf_set_iden_off_1(dw_1) //关掉本地datastore的自增 wf_set_iden_off_1内容: //将指定datastore 的自增字段设置为 off string ls_colcount long ll_colcount, i string ls_ColName ls_colcount = ar_ds.Describe("DataWindow.Column.Count") if integer (ls_colcount) > 0 then ll_colcount = integer (ls_colcount) else return end if string ls_on, ls_err for i = 1 to ll_colcount ls_ColName = ar_ds.Describe("#" + string(i) +".name") ls_on = ar_ds.Describe("#" + string(i) +".Identity") if ls_on = 'yes' then ar_ds.modify (ls_ColName + ".Identity = 'no'" ) end if next 5.开始copy, 6.update 结束
|