home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Power-Programmierung
/
CD1.mdf
/
pascal
/
library
/
dos
/
topaz
/
qnr
/
read.me
< prev
Wrap
Text File
|
1991-08-14
|
5KB
|
140 lines
QNR - V01.00
(C)opyright 1991 - Caboose Software Engineering
------------
INTRODUCTION
------------
QNR, or Query N' Report, was developed to provide a more powerful filter for
Topaz. Currently, user defined queries were difficult or impossible. Now,
with the additon of the initial release of QNR, the filter can be a powerful
xBase like query. The query is built ala a dBase III+ Assist query build, but
can also be typed in on a command line and parsed. For syntax sake, the first
method is preferred and recommended.
For those of you creating professional systems in Topaz, I promise you that
this unit is now and will progress to be a powerful query add-on. As with
typical xBase filters and even Topaz filters, the speed of a system utilizing
a query is greatly reduced. But for subsets and reports, QNR is truly
invaluable.
As in virtually the first release of all units hacked together to fill a
specific need, there are some powerful features and some noticable ommissions.
As comments, and registrations, come in I will gladly update the software
to include a host of powerful features.
--------------
FILES INCLUDED
--------------
READ.ME - This file of limited documentation.
QNR.HED - Header file for QNR.
QNR.TPU - A pre-compiled TPU, using Turbo Pascal 6.0 and Topaz 3.0.
QNRDEMO.PAS - A demonstration program showing a possible QNR implementation.
QNRDOT.PAS - A program to simulate a "dot prompt" query.
----------------
WHERE TO GET QNR
----------------
The latest shareware release of QNR can be downloaded from the following
BBS systems:
Software Science BBS @ 1-415/467-6786
Programmers Corner @ 1-301/596-1180
or you can always receive the absolute latest version directly from
the author for the $25 registration fee at his Silver Spring address.
-----------------
ROUTINES INCLUDED
-----------------
Procedure GetQuery ( VAR QueryString : String );
+ This procedure is similar to assist and can be used to retrieve a
query in a QNR syntactically correct format.
Function ProcessQuery : Boolean;
+ This function validates whether a query is valid for processing.
Function ParseQuery : Boolean;
+ This function is used as the actual SET_FILTER_TO() condition. Please
note that the string which contains the query to be processed MUST be
moved into QueryString.
Procedure InitializeQuery;
+ This procedure initializes the internal tables for the query function.
It is recommended that this is only initialized before a ProcessQuery
call.
----------------------
HOW TO INCORPORATE QNR
----------------------
The best suggestions I have is to closely examine the demonstration included
in this ZIP file, QNRDEMO. A long tutorial of QNR is not necessary nor
is it going to happen in this short READ.ME.
You will note that you can type in a condition based on another field. Try
a query like 'AGE > WIFES_AGE' to compare fields within a database instead
of versus a literal value. This feature was just added so there may be bugs
related to this.
Also note that a string must be enclosed with double quotes, not single. For
example:
STATE = "MD" is valid but,
STATE = 'MD' is not.
-----------------------
WHAT'S IN STORE FOR QNR
-----------------------
+ Data dictionary support.
+ Relational database support.
+ The R. In other words, a configurable report writer and generator.
+ Possibly a unit to graph dBase data.
+ More intelligent parser for "dot prompt" entry.
+ Ability to edit, expand and contract queries.
+ Expanded demonstration software supporting cataloging frequent queries.
+ Support of non-exact queries via UPPERCASE conversion of data.
+ Increase in speed of query processing via assembler routines.
------------
REGISTRATION
------------
If you find QNR useful in your computing activities, please consider
sending a donation to cover development time and ingenuity. If you use QNR
in your systems, please think of life without this valuable unit! A $25
donation is suggested, which I believe is an extremely reasonable sum for
this initial release. Registered users will receive a free upgrade to the
all minor releases of QNR, and a substantial discount on any major releases.
If you send a diskette with a pre-stamped (three stamps) disk mailer, I will
send along the latest version of QNR and any other shareware utilities I have
produced. Source code for all Caboose Software Engineering software is
available on request for an additional cost.
All shareware libraries may freely distribute this package provided I am
notified of the inclusion.
Thanks for your support. As always, comments are welcome and appreciated.
-Barry Smith
Caboose Software Engineering
2921 Bluff Point Lane
Silver Spring, MD 20906
301/460-1437
----------------
REVISION HISTORY
----------------
V01.00 (09 Aug 91)
o First public release. Written in Turbo Pascal 6.0 using the Topaz
commercial dBase library.