visioFox使用

BROWSE LAST --查看最后一个文件
close all --关闭显示

● brow for fxywlb=‘FXA6’

● brow for inlist(fxzqdm,‘159100’,‘169100’)

从右边查询3位字符
brow for right(Jgtgdy,3)=‘321’
select right(Jgtgdy,3), from Sjsjg0123zb.dbf

从左边查询3位字符
brow for left(Jgtgdy,3)=‘321’
select left(Jgtgdy,3), from Sjsjg0123zb.dbf

截取指定位置指定长度
brow for substr(Jgzqdm,1,3)=‘161’
select substr(Jgzqdm,1,3), from Sjsjg0123zb.dbf

*修改
update Jsmx03_js961 set Ywlx=‘812’ where Ywlx=‘811’

*删除
delete for Ywlx=‘811’ and Qsbz=‘232’
pack

delete for Ywlx<>‘811’ and Ywlx<>‘812’
pack

*替换
replace Ywlx with ‘811’ for Ywlx=‘812’

replace all Rq with ‘20200327’

replace all Jgcjrq with date(2020,03,26)

*数据筛选
set filter to Jgzqdm=‘161117’
brow

*排序
index on Jgtgdy to Sjsjg0123zb
brow

*加前缀
replace all Jgzqzh with ‘0199’+Jgzqzh

*减前缀，查询并替换
replace all Jgzqzh with right(Jgzqzh,12)

*创建DBF文件
copy structure to C:\Users\test.dbf

*拷贝数据
copy to C:\Users\test.dbf for inlist(Jgzqdm,‘161117’,‘163824’,‘164703’)

select * from Sjsjg0123zb where inlist(Jgzqdm,‘161117’,‘163824’,‘164703’) into dbf C:\Users\test.dbf

*追加数据
append from C:\Users\Sjsjg0123zb.dbf