home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Monster Media 1993 #2
/
Image.iso
/
database
/
qdbf.zip
/
QUERY.DOC
< prev
Wrap
Text File
|
1993-06-18
|
3KB
|
91 lines
Syntax: Q <dbfname>
This program allows you to create reports of any DBF file.
After starting the program from the DOS prompt, you are able to select
the fields in the sequence they must appear on the report.
With the [TAB] key you can switch between field-selection and sequence-
selection. In the sequence-selection box you can define the fields on
which the report must be ordered (ascending or descending).
With the [F10] key you can switch to the filter-setup screen. In this box
you can define the selection-criteria that the records on the report
must meet. With the [(shift)TAB] key you can walk through the lines that
you have entered. After setting the filter, you can go back to the selection
screen with the [Ctrl+Enter] key.
If you press [Ctrl+Enter] on the selection screen the selection of the records
will start. You will see the progress on your screen.
Then see how beautiful it all works: The report appears on your screen and
you can send it to the printer or to a diskfile.
NB:
If you use DOS 6.00 and your config.sys file contains the line EMM386 NOEMS,
then you must add NOVCPI as extra parameter to EMM386.
------------------------------------------------------------------------------
You are allowed to copy this program and distribute it. You may install it
for your customers, but you are not allowed to charge anything for it.
------------------------------------------------------------------------------
Did you also try the Clipper source code generator GENCLP? It is available
on may BBSs.
This generator is a high quality ShareWare product named GENCLP20.ZIP.
The latest version of this program is always frequestable from HEKOM BBS
Harmelen Holland: Fidonet-node 2:500/223 or 2:500/281. Use Magic-name GENCLP.
The generator:
=============
- Creates error-free multi-user Clipper program sources (Object-Oriented-
like) for a complete working system
- Creates sources of GEN.LIB and NGEN.LIB
- Checks consistency of defined system
- Creates compile/link MAKE files
- Includes meta-data repository
The generated sources include:
=============================
- Full standard Clipper code
- Full generator-independent
- Full customizable
- Efficient recordlocking mechanisms for effective networking
- Automatic color-screen detection and support
- Multi-page screen support (PgUp/PgDn) without disturbing GET validations
- Quick screen exit (PgDn) without disturbing GET validations
- Automatic DBF and NTX creation on first start up
- Helpscreens on strategic moments
- Re-index facility
- Recycling of deleted records (eliminates use of PACK command)
- Data integrity support to maintain unique keys in DBF
- Key search facility
- Controlled DBF print facility
- Look and feel menu-structures
- Prepared to use authorization mechanisms
- Structured modular
Get it and try it. You won't be disappointed. Good luck!
-------------------------------------------------------------------------------
For questions send a message to:
Name: Jack Van Hoof
BBS : ... - 31 - 3483 - 4072 (HEKOM Harmelen Holland)
or
BBS : ... - 31 - 01180 - 39017 (City BBS)
or
use the Clipper World Echo-mail