home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Monster Media 1993 #2
/
Image.iso
/
database
/
addqbe24.zip
/
README
< prev
next >
Wrap
Text File
|
1993-06-06
|
5KB
|
111 lines
ADDONQBE (C) Copyright 1992, 1993
Version 2.4
Suggested BBS Name: ADDQBE24.ZIP
A Shareware package from Lightwave Software Engineering
Harold Chattaway
Lightwave Software Engineering
3 Old Northfield Rd
Ashby, MA 01431
(508)342-6016
CIS:72540,140
ADDONQBE is a powerful Query by Example program that can be
added onto your existing Foxpro 2.5 application with the addition of one
ON KEY LABEL command. When activated, it overlays your current Data
Entry (DE) screens and turns it into a QBE screen! No additional coding
other than the addition of one ON KEY LABEL command! Your users DO NOT
have to use anything other than the DE screens they are already used to.
And they do not have to know how to use a program like Foxpro's RQBE.
This is an updated version of the program that appeared in the November 92
issue of Foxtalk. I have added the ability to:
1. Save filters in a filter library for easy retreival.
When filters are being picked from list, the full English
version of the filter is displayed in a filter expression window.
2. Export the current database in all the formats that Foxpro
supports, i.e WK1, WKS, original Foxbase format, SDF, Delimited, etc,
with the filter on or off, consisting of the fields that you pick.
3. Generate and save user defined labels in the same library as
standard reports. Program will call the label generator or the
report generator when picked from the library.
4. Browse the filtered file to allow the user to more easily see
if the filter is correct. This browse feature will use the Data
Dictionary(DD) to generate the headers in the browse window if field
desciptions are available in the DD.
5. Abilty to manage the index tags associated with the current DBF.
You can select the primary index from a pick list of the tags that
are available, delete a tag, and create new tags. THIS IS A GOOD ONE!
6. On-line Help is available by pressing F1 once ADDONQBE has been
activated. These new features are described in the HELP system.
BUG FIXES:
1. If doing direct reads, programmed crashed... Fixed
2. If change sort order and then build filter, crashed. Fixed
In order to hook in the ADDONQBE application, just add the line: ON KEY
LABEL F10 DO ADDONQBE.APP with WONTOP(),VARREAD(). This can go into the
setup code for a particular screen or in the main program of an
application. Though this is the shareware version, you can still try this
with one of your own applications. It's fully functional, there just is not
any source code.
To best see how the program operates, run the sample screen by typing in
DO QBETEST. In the window footer you will see "F10=Add on Query by
Example". Put the cursor in a field you wish to set a condition on and
press F10. A menu of comparison operators will appear. Pick one of these
and enter the comparison value. Press ESC or choose "Return to DE Screen"
to pick an additional field that you would like to add the filter
expression. As the filter is built, you will see the expression being
built in a window. When it is what you want, select "Set Filter" from the
menu. This will impose the filter on the file and only you to view the
records that match the filter. Press F3 & F4 to view the previous and next
records in the file. Try running a sample report. Also notice the Data
Dictionary menu option. Changing the description of the field names here
will make the fields make more sense to the end user.
Play around with the sample to see how easy it is to use! It is very
simple yet very powerful.
For full source code, project file, and documentation please register your
copy, as this is shareware. After pressing F10 to call up ADDONQBE, press
F2 to view registration information.
Future versions will have the Multi-Table Query feature complete. The
version in this release is not fully functional. Also ADDONQBE will
be converted for Foxpro for Windows.
Thanks you very much. Please provide feedback if so inclined! It would be
very helpful! I will be making updates, but still would like to hear from
more people.
╔═══════════════════════════════════════╗
║ LIGHTWAVE SOFTWARE ║
║ ║
║ ENGINEERING ║
║ ────────────────────────────────── ║
║ * Custom Database Applications ║
║ * Software Consultation ║
║ * Database Design CIS:72540,140 ║
║ Harold Chattaway (508)342-6016 ║
╚═══════════════════════════════════════╝
"Where the Art of Programming is a Science..."
Harold Chattaway
Lightwave Software Engineering
3 Old Northfield Rd
Ashby, MA 01431