home *** CD-ROM | disk | FTP | other *** search
dBase Query | 1992-03-10 | 3.0 KB | 30 lines |
- * dBASE IV .QBE file 8
- CLOSE DATABASES
- SET EXACT ON
- SELECT 1
- USE NAMES.DBF
- SET FILTER TO STATE="DC"
- GO TOP
- NAMES.DBF
- :Names.dbf*$i
- :LASTNAME*$i
- :FIRSTNAME*$i
- :ADDRESS*$i
- :CITY*$i
- :STATE*$i
- :ZIP*$i
- :PHONE*$i
- :BUSINESS*$i
- :Lastname+Firstname*$i
- :TRIM(Lastname)+Firstname*$i
- ,xx:"DC"*$i
- ,xx:*$i
- :namesqry*$i ,
- *$i ,
- *$i ,
- *$i ,
- *$i ,
- *$i ,
- *$i ,
- *$i ,
-