home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Shareware Overload
/
ShartewareOverload.cdr
/
database
/
rquery2.zip
/
RQUERY.DOC
< prev
next >
Wrap
Text File
|
1990-06-14
|
7KB
|
265 lines
RQUERY
Copyright (C) SOFT-TECH OFFICE SYSTEMS 1990
342 MEADOWRIDGE DRIVE
RIDGELAND, MS 39157
FAX: 601-856-8361
REVISED: 6/10/1990
**NOW ALLOWS YOU TO CHOOSE UP TO 10 COLUMNS IN ANY ORDER AND SET A
CONDITION TO EACH! ALSO THE CODELOCKED VERSION TO WORK WITHIN
EXISTING RBASE APPLICATIONS IS INCLUDED!**
LEARNING TO USE RQUERY
The best way to learn how to use RQUERY (or any product)
is to use it.
This guide is not intended as a detailed manual. The program is
basically self explanatory. This stand alone program works only
with databases created by Microrim's Rbase.
To operate the program you must have all of the files listed below,
except this RQUERY.DOC, FORM.TXT and the RQUERY.APX file, in the
directory where the RBF files are located.
See "CODELOCK VERSION".
file
The program creates a temporary file called "RQUERY.DAT" to store
your query, then erases it. Therefore do not have any other file
by that name in the current directory.
BROWSE COM
QUERY EXE
RQUERY OVL
RQUERY OBJ
RQUE$0 OBJ
RQUERY MSG
RQUERY LNK
RQUERY MAP
RQUERY DOC
FORM TXT
After starting the program, you will be given a list of all Rbase
databases in the current directory. Simply highlight the one you
wish to use and press ENTER. You will then be offered a list of
all the existing tables in the current open database. Highlight
your choice and press ENTER. You will then be shown all of the
columns in the chosen table. You may choose to use all by pressing
ESC or you may choose up to 10 in any order you wish to view by
highlighting each in turn. You will then go to the Sort screen.
Once again you will be shown all of the columns in the current
table. You must choose at "LEAST ONE". After choosing a sort
column you can then choose "Ascending" or Descending". You can
have up to 3 sorts. If you wish fewer than three, press ESC to go
to the next screen after choosing at least one.
You will now go to the conditions screen. Once again you will be
able to choose your conditions by highlighting your choice. When
you press ENTER you will be given a list of conditions to choose
from (eg. EQ, GT, CONTAINS, etc.) After choosing the condition you
will be prompted, if necessary for input to match the condition
against. You must choose at least one condition. If you wish to
select everything in your database match any field with EXISTS.
You may have up to 10 conditions. After each choice you are
prompted to choose one of the following: AND, OR, AND NOT, OR NOT,
(DONE). Choose DONE when finished with your conditions.
The program will then select the data and present the following
menu.
+------------ Select Print Routing--------+
| SCREEN PRINTER NEXT QUIT |
+-----------------------------------------+
If you choose SCREEN the report will be presented to the screen
allowing you to scroll up, down and to either side with the cursor
control keys, tab key, or the page up and page down keys. END will
take you to the bottom of the report and Home will take you back to
the beginning. Press ESC and then ENTER to return to the above
menu. Choosing PRINTER will print the report to your printer. It
uses no printer control commands, so you will have to put your
printer in condensed print format if you choose more columns than
will fit on you paper normally. Choosing Next will return you back
to the beginning of the program for another custom Query. Choosing
QUIT will end the program.
*************************
CODELOCKED BINARY VERSION
*************************
The codelocked binary version is designed to be incorporated into
your own existing applications. You can then hard code the
database and the table to use in the query.
All that is necessary is the RQUERY.APX file and the BROWSE.COM
file.
Simply set the database name to the varible "DBNAME" and the table
to "TABNAME". This issue a call to run RQUERY in RQUERY.APX.
Do not have any of the following varibles active at the time or
they will be cleared.
*(SET UP VARIABLES TO BE USED IN RQUERY)
err, cols1, cols2, cols3, cols4, cols5, cols6, cols7, cols8, cols9,
cols10, sort1, sort2, sort3, cond1, cond2, cond3, cond4, cond5,
cond6, cond7, cond8, cond9, cond10, opr1, opr2, opr3, opr4, opr5,
opr6, opr7, opr8, opr9, opr10, val1, val2, val3, val4, val5, val6,
val7, val8, val9, val10, colc1, colc2, colc3, colc4, colc5, colc6,
colc7, colc8, colc9, colc10, dir1, dir2, dir3, vars, tabnm,
sortcls, wherecls, numrows, sortcls
DISTRIBUTION AND REGISTRATION
As you know software copyright violation is rampant. This is
why we have created RQUERY. RQUERY allows access to codelocked and
compiled RBASE applications without the need of purchasing a copy of
RBASE to do custom lookups and reports. Rquery is availabel for
distribution, there will be no need to pirate copyrighted software to
obtain access to ones own database.
Please feel free to give RQUERY to you friends. We
are counting on you as a participant in the largest distribution
network in the nation (the owners and users of PCs) to make
RQUERY a popular product. With strong user support,
RQUERY will be enhanced with new features and capabilities
making it more powerful.
For twenty (20) dollars you can become a registered owner of
RQUERY. For your $20.00 you will appease your conscience
about using unregistered software, receive notice of updates,
and a copy of the latest version of RQUERY.
The file FORM.TXT can be used as an order form.
SEND A CHECK TO:
Soft-Tech Office Sustems
342 Meadow Ridge Dr.
Ridgeland, MS 39157
We thank you for your support.