Code: Select all
db(type=aremos) abank1.bnk
db(type=aremos) abank2.bnk
wfcreate(wf=work, page=a) a 1901 2099
smpl 1968 2016 ' create x in abank1
genr x = 1
copy(o) x abank1::x
delete x
close abank1
smpl 2017 2017 ' create x in abank2
genr x = 2
copy(o) x abank2::x
delete x
close abank2
smpl @all
' copy and merge x from abank2 to abank1
dbopen(type=aremos) abank2.bnk
dbopen(type=aremos) abank1.bnk
copy(m) abank2::x.a abank1::x.a
fetch(db=abank1) x
smpl 2016 2017
x.sheet ' correct result should be 1 2