如果能保证所有照片存在,可直接用原来的表为数据原,否则用临时表。
建立一个空白照片文件 blank.jpg
select xh,xb,xm,sfzh,space(20) zp from table into cursor tbtmp READWRITE
repl zp with allt(xh)+'.jpg' all
scan
fnm=allt(xh)+'.jpg'
if !found(fnm)
repl zp with 'blank.jpg'
endif
endscan
建立一个空白照片文件 blank.jpg
select xh,xb,xm,sfzh,space(20) zp from table into cursor tbtmp READWRITE
repl zp with allt(xh)+'.jpg' all
scan
fnm=allt(xh)+'.jpg'
if !found(fnm)
repl zp with 'blank.jpg'
endif
endscan
dBase有人接盘了。