vfp常用命令

vfp常用命令

copy to oldzhuan1.dbf for xhjm=??709*

copy to oldzhuan1.dbf for xhjm="??709*"

copy to oldzhuan1.dbf for xhjm="709"

copy to oldzhuan2.dbf for xhjm="709"

copy to oldzhuan2.dbf for xhjm like ??709*

BROWSE LAST

copy to oldzhuan2.dbf for xhjm like __709%

copy to oldzhuan2.dbf for xhjm like '__709%'

copy to oldzhuan2.dbf for xhjm like '--709%'

select * from oldzhuan1 where xhjm like '__709%'

select * from oldzhuan1 where xhjm like '--709%'

select * from oldzhuan1 where xhjm like '??709%'

select * from oldzhuan where xhjm like '__709%'

copy to oldzhuan1.dbf for xhjm=??709*

copy to oldzhuan1.dbf for xhjm="??709*"

copy to oldzhuan1.dbf for xhjm="709"

copy to oldzhuan2.dbf for xhjm="709"

copy to oldzhuan2.dbf for xhjm like ??709*

BROWSE LAST

copy to oldzhuan2.dbf for xhjm like __709%

copy to oldzhuan2.dbf for xhjm like '__709%'

copy to oldzhuan2.dbf for xhjm like '--709%'

select * from oldzhuan1 where xhjm like '__709%'

select * from oldzhuan1 where xhjm like '--709%'

select * from oldzhuan1 where xhjm like '??709%'

select * from oldzhuan where xhjm like '__709%'

copy to oldzhuan2.dbf for xhjm like '__709%'

select * from oldzhuan where xhjm like '__709%'

COPY TO g:\2010年7月成绩(旧系统)\dbf格式的本学期成绩查询用\oldzhuan.xls TYPE XL5 select * from oldben where 学号 like '__109%'

sort to oldben.dbf on xhjm /a

sort to oldben.dbf on 学号 /a

Visual FoxPro 6.0 数据库命令

一、创建数据表的结构

命令1:CREATE [路径][表名]

例子:在A盘创建GZ2数据表。

CREATE A:GZ2

命令2:CREATE [新表名] FROM [旧表名]

Word文档免费下载Word文档免费下载:vfp常用命令 (共8页,当前第1页)

你可能喜欢

  • 二级VFP
  • VFP教程
  • foxpro教程
  • vfp教案
  • VFP实例
  • 命令大全
  • Excel使用技巧大全(超
  • SQL语句教程

vfp常用命令相关文档

最新文档

返回顶部