FLAG Db DoubleCheck
Version 6

Database Duplicate Checking System










_______
____|__ | (tm)
--| | |-------------------
| ____|__ | Association of
| | |_| Shareware
|__| o | Professionals
-----| | |---------------------
|___|___| MEMBER










_________________________________________________________________
R.1.0.1
Copyright 1988 Matthew G. Maier.
All Rights Reserved




FLAG Db DoubleCheck Version 6 Table of Contents

_________________________________________________________________




Table of Contents



INTRODUCTION . . . . . . . . . . . . . . . . . . . . . . . . 1

REQUIREMENTS . . . . . . . . . . . . . . . . . . . . . . . . 2

DISCLAIMER . . . . . . . . . . . . . . . . . . . . . . . . . 3

COPYRIGHT . . . . . . . . . . . . . . . . . . . . . . . . . . 3

DISTRIBUTION . . . . . . . . . . . . . . . . . . . . . . . . 4

LICENSE . . . . . . . . . . . . . . . . . . . . . . . . . . . 4

SHAREWARE . . . . . . . . . . . . . . . . . . . . . . . . . . 4

REGISTRATION . . . . . . . . . . . . . . . . . . . . . . . . 4

ACKNOWLEDGEMENTS . . . . . . . . . . . . . . . . . . . . . . 5

TRADEMARKS and COPYRIGHTS . . . . . . . . . . . . . . . . . . 5

Getting Started . . . . . . . . . . . . . . . . . . . . . . . 6
Installation . . . . . . . . . . . . . . . . . . . . . . 6
Unpacking . . . . . . . . . . . . . . . . . . . . . 6
Configuration . . . . . . . . . . . . . . . . . . . . . 6
Environment Variables . . . . . . . . . . . . . . . 6
FLAG6 . . . . . . . . . . . . . . . . . . . . 7
FLGFLT . . . . . . . . . . . . . . . . . . . . 7

Main menu . . . . . . . . . . . . . . . . . . . . . . . . . 10
Data File Selection . . . . . . . . . . . . . . . . . 12
Pick a file . . . . . . . . . . . . . . . . . . 12
Type in name . . . . . . . . . . . . . . . . . . 12
New File Spec . . . . . . . . . . . . . . . . . . 13
Change directory . . . . . . . . . . . . . . . . 13
Drive change . . . . . . . . . . . . . . . . . . 13
Quit . . . . . . . . . . . . . . . . . . . . . . 14
Field Selection . . . . . . . . . . . . . . . . . . . 15
Expression . . . . . . . . . . . . . . . . . . . 15
Check Key . . . . . . . . . . . . . . . . . . . . 16
Deselecting fields . . . . . . . . . . . . . . . 16
Accepting your choices . . . . . . . . . . . . . 16
Number of Checks . . . . . . . . . . . . . . . . . . . 17
Starting position . . . . . . . . . . . . . . . . 17
Number of checks . . . . . . . . . . . . . . . . 17

_________________________________________________________________
R.1.0.1
Copyright 1988 Matthew G. Maier.
All Rights Reserved
i




FLAG Db DoubleCheck Version 6 Table of Contents
_________________________________________________________________




Options / Setup . . . . . . . . . . . . . . . . . . . 18
Ignore Character Case . . . . . . . . . . . . . . 20
Ignore ALL spaces when checking . . . . . . . . . 21
Ignore ALL punctuation characters while checking 22
Write report to a file . . . . . . . . . . . . . 23
Print report to printer . . . . . . . . . . . . . 24
Print Statistics to printer . . . . . . . . . . . 25
Print with Graphics characters . . . . . . . . . 26
Show Statistics while checking . . . . . . . . . 27
Mark EXACT duplicates . . . . . . . . . . . . . . 28
Set HI and LO duplicate levels . . . . . . . . . 29
Pick fields to use in report(s) . . . . . . . . . 30

APPENDIX A -- Hints . . . . . . . . . . . . . . . . . . . . 31
Picking Data Files . . . . . . . . . . . . . . . . . . 31
Picking fields . . . . . . . . . . . . . . . . . . . . 31
Number of checks to do . . . . . . . . . . . . . . . . 32

APPENDIX B -- History . . . . . . . . . . . . . . . . . . . 33
Revision History by Version . . . . . . . . . . . . . 33
Version 6 . . . . . . . . . . . . . . . . . . . . 33
R.1.9.2 . . . . . . . . . . . . . . . . . . 33
R.1.8.1 . . . . . . . . . . . . . . . . . . 33
R.1.0.1 . . . . . . . . . . . . . . . . . . 34
R.1.0.0 . . . . . . . . . . . . . . . . . . 34
Version 5 . . . . . . . . . . . . . . . . . . . . 34
R.0.3.0 . . . . . . . . . . . . . . . . . . 34
R.0.2.8 . . . . . . . . . . . . . . . . . . 34
R.0.2.0 . . . . . . . . . . . . . . . . . . 34
R.0.1.3 . . . . . . . . . . . . . . . . . . 35
R.0.1.0 . . . . . . . . . . . . . . . . . . 35

APPENDIX C . . . . . . . . . . . . . . . . . . . . . . . . 36
Technical Support / Author . . . . . . . . . . . . . . 36
US Mail . . . . . . . . . . . . . . . . . . . . . 36
Telephone . . . . . . . . . . . . . . . . . . . . 36
Hours - Weekday . . . . . . . . . . . . . . 36
Hours - Weekend . . . . . . . . . . . . . . 36
Email . . . . . . . . . . . . . . . . . . . . . . 36

APPENDIX D -- Quick Reference . . . . . . . . . . . . . . . 38

APPENDIX E -- ASP - Ombudsman . . . . . . . . . . . . . . . 40

APPENDIX F -- Registration . . . . . . . . . . . . . . . . 41
Pricing, Site License, and discount rate chart . . . . 42



_________________________________________________________________
R.1.0.1
Copyright 1988 Matthew G. Maier.
All Rights Reserved
ii




FLAG Db DoubleCheck Version 6 Introduction
_________________________________________________________________



INTRODUCTION


Welcome to FLAG Db Double Check Version 6!

FLAG Db DoubleCheck Version 6 is designed to check
dBASE III+, and compatible, .DBF data files for dupli-
cates.

FLAG Db DoubleCheck Version 6 features:

* Use dBASE III/III+, Clipper, QuickSilver, FoxBASE+, and
other close compatible, data files

* Check any field(s) in the table, character, numeric,
date, and/or logical

* Settings for:

Where to start checking a field
How much of a field to check
Case sensitivity
Ignore spaces within fields

* Identification of three duplication levels: Exact,
Probable, and Possible

* Reports:

Settings for:

Level(s) of duplication to include in rep-
ort(s)
Printing of duplication report(s)
Write duplication report to a file
Printing of statistics as a separate report

* While checking, optionally, display statistics

* Command line parameters for ease of operation









_________________________________________________________________
R.1.0.1 23-Jul-1990
Copyright 1988 Matthew G. Maier.
All Rights Reserved.
^N:42




FLAG Db DoubleCheck Version 6 Introduction
_________________________________________________________________



There have been many changes in version six of FLAG Db Double-
Check.
It has been greatly enhanced to be more flexible and easy to use.

In the interest of brevity I will start off with the usual:
requirements, disclaimer, copyright notice, and acknowledgements.
We will then run through an explanation of the menus in FLAG Db
DoubleCheck Version 6.


REQUIREMENTS

FLAG Db DoubleCheck Version 6 needs:

An IBM or close compatible
A minimum of 512K RAM installed (640K is recommended)
A hard disk is suggested, but a dual floppy system will
work.
You will need enough room on the disk, (hard
or floppy), to create an index file
The file to check MUST be compatible with the dBASE
III+ .DBF data file format.
(This DOES NOT include dBASE IV or FoxPro
data files). The file should not be
encrypted or in any other way protected or
altered.

Networks:

FLAG Db DoubleCheck Version 6 is NOT a multi-user application.
FLAG Db DoubleCheck Version 6 is network AWARE, that is the limit
to its networking abilities. It, simply, knows if it is on a
network or not, and will take appropriate file locking action(s)
if it is. The only network OS that FLAG Db DoubleCheck Version 6
has been tested on, by me, is Novell's NetWare.

NOTE: If you are running on a network it is your
responsibility to ensure that you have Create and
Delete rights in the directory where you will be work-
ing. You will also need to be able to use the data file
to be checked in NON-shareable (LOCKED/EXCLUSIVE) mode.

NOTE: It will take time to index the data file. This
will take even longer on networks, and with larger data
files. Also, make sure you have enough room to create
the index. FLAG Db DoubleCheck Version 6 will make an
attempt to check if there is enough room and inform you
if it doesn't think there is adequate space.

_________________________________________________________________
R.1.0.1 23-Jul-1990
Copyright 1988 Matthew G. Maier.
All Rights Reserved.
^N:42




FLAG Db DoubleCheck Version 6 Introduction
_________________________________________________________________



Known incompatibilities:

I have disabled default use of exPanded memory because of exist-
ing problems with some exPanded memory managers.


DISCLAIMER

I, Matthew G. Maier, hereby disclaim all warranties relating to
this software (FLAG Db DoubleCheck Version 6), whether express or
implied, including and without limitation to, any implied warran-
ties of merchantability or fitness for a particular purpose. I
will not be liable for any special, incidental, consequential,
indirect, or similar damages due to the use or misuse of this
software or for any other reason, even if I or an agent of mine
have been advised of the possibility of such damages. In no
event shall my liability for any damages ever exceed the price
paid for the license to use this software, regardless of the form
of the claim. The person using the software bears all risk as to
the quality and performance of the software.



COPYRIGHT

FLAG Db DoubleCheck Version 6, the package, and any/all accompa-
nying files are all copyrighted under U.S. and international
copyright law by Matthew G. Maier. Defraud of the codes and
terms of these copyright law(s) will result in criminal prosecu-
tion.

FLAG Db DoubleCheck Version 6 IS NOT placed into the public
domain, it is SHAREWARE and you are obligated to register this
software if you use it beyond the appointed trial period.

The FLAG Db DoubleCheck version 6 package, including, but not
limited to: FLAG6.EXE,
FLAG6A.DAT,
FLAG6B.DAT,
FLAG6.CFG,
FLAG6HIS.DBF,
FLAG6.DOC,
and (optionally) README.F6;

files may NOT be reproduced, sold, copied, disassembled, reverse
engineered, incorporated into, or bundled with, any other pack-
age(s), or application(s), or in any other way modified without
the express WRITTEN consent of the author.

_________________________________________________________________
R.1.0.1 23-Jul-1990
Copyright 1988 Matthew G. Maier.
All Rights Reserved.
^N:42




FLAG Db DoubleCheck Version 6 Introduction
_________________________________________________________________



DISTRIBUTION

You may upload the FLAG Db DoubleCheck Version 6 SHAREWARE ver-
sion, in its unmodified archival form, provided all accompanying
documentation and data files are included in the archive(s).
Commercial distributors/vendors must obtain a WRITTEN distribu-
tion license from the author before they may distribute FLAG Db
DoubleCheck, (any version and/or release from Version 5 Release
1.0.0 forward), in any form; unless the distributor(s) are ASP
approved/authorized vendor(s). Groups may charge a processing and
handling fee, not to exceed $7.00 (U.S. Currency).


LICENSE

You are granted a limited license to use FLAG Db DoubleCheck
Version 6 for a trial period, 30 days, pending evaluation prior
to purchase. Registered users may not reproduce or distribute
their serialized copy of FLAG Db DoubleCheck Version 6 or any
accompanying files. You may install FLAG Db DoubleCheck Version
6 on more than one computer, but are limited to ONE copy
running/active/in use/in operation at the same/parallel time.


SHAREWARE

FLAG Db DoubleCheck Version 6 is distributed as SHAREWARE. What
is SHAREWARE? Well, SHAREWARE is a concept that allows you to
test, for a trial period, a fully operational product before
purchasing it. By using the product, beyond the trial period,
you are agreeing to purchase the product. If you do not remit
payment, and continue to use the product, after the prescribed
trial period, you are breaking your part of the agreement. This
makes it harder for SHAREWARE authors to produce quality software
on a try-before-you-buy basis and you will have to live with your
conscience.


REGISTRATION

Why should you register? When you register you will be sent the
latest version/release of FLAG Db DoubleCheck, (all fixes are not
uploaded). FREE major upgrade(s) and technical support for one
year from purchase date. The SHAREWARE notice will be removed
from your registered version(s) and it/(they) will be serialized
with your registration ID and name(s), or company name(s). At
this time, printed documentation is not available, this may


_________________________________________________________________
R.1.0.1 23-Jul-1990
Copyright 1988 Matthew G. Maier.
All Rights Reserved.
^N:42




FLAG Db DoubleCheck Version 6 Introduction
_________________________________________________________________



become a future option. If it does, all registered users will
receive this documentation FREE of charge.

Registered users have priority in all dealings: technical sup-
port, upgrades, enhancements they would like, etc... If you find
FLAG Db DoubleCheck Version 6 useful, would like to see enhance-
ments made to it, and want to support the SHAREWARE concept, then
register your version, and please, register all SHAREWARE you
find useful.

Registered users are licensed to use their version(s) of FLAG Db
DoubleCheck, (whichever version/release they have), on one ma-
chine at a time and may NOT, under any circumstances, distribute
their copy.

The price of FLAG Db DoubleCheck Version 6 is $22.95 + $2.50 S/H,
[$25.45], (U.S. currency). Please see the registration form,
site licensing instructions, and pricing information, at the end
of this documentation, for more details.


ACKNOWLEDGEMENTS

I would like to thank:

Bill Lynott for his continued support and feedback during the
development of FLAG.

Bob Laszko of Data Management Systems for developing DMSERR and
DMSOOP which I have found to be very valuable tools.



TRADEMARKS and COPYRIGHTS

The FLAG Db DoubleCheck Duplicate Checking System is distributed
using LHarc 1.13c Large Model SFX.

FLAG Db DoubleCheck is a copyright of Matthew G. Maier.
Clipper is a registered trademark of Nantucket Corporation.
FoxBASE+/FoxPro is a registered trademark of Fox Software.
dBASE III/III+ is a registered trademark of Ashton-Tate.
Quicksilver is a registered trademark of WordTech Systems Inc.
NetWare is a registered trademark of Novell.
LHarc 1.13c SFX is a copyright of Haruyasu Yoshizaki.
DMSERR and DMSOOP are copyrights of DMS.



_________________________________________________________________
R.1.0.1 23-Jul-1990
Copyright 1988 Matthew G. Maier.
All Rights Reserved.
^N:42




FLAG Db DoubleCheck Version 6 Up and Running
_________________________________________________________________



Getting Started


Installation:

In order to install FLAG on your computer system, copy
the .EXE file(s) from drive A: to the target drive (C:
D: B: etc.)

It is advised that you place FLAG in a separate direc-
tory of its own to insure that the FLAG*.* data files
stay with the FLAG6.EXE executable file, we suggest a
directory name of 'FLAG6'.

Unpacking:

If you received a diskette containing three .EXE
files the following instructions pertain to you.
Otherwise if you received FLAG in archived form
(i.e. FLAG.ZIP) all you need to do is extract the
file into the directory where you would like FLAG
to live.

To unpack the FLAG system, after copying the dis-
tribution file(s), type the name of file(s) with
an extension of 'EXE'. You will see each file(s)
opening screen and will be prompted whether or not
to continue. If you respond by pressing the 'Y'
key, each file will un-archive itself into the
current directory. (see INSTALL.TXT for un-archiv-
ing to different [drive][directory] instructions.)

Type:
FLAG6EXE (the executable program)
FLAG6DOC (this documentation)
FLAG6DAT (the data files FLAG needs)

Configuration:

Environment Variables

FLAG supports two environmental variables / DOS
variables. Both of which can be set from the DOS
prompt or via a batch file (or the autoexec.bat
file). The first controls FLAG's use of certain
system resources, explained below. The second
variable 'FLGFLT' is new with this release of FLAG
(r.1.9.2). It supports the setting of a filter

_________________________________________________________________
R.1.0.1 23-Jul-1990
Copyright 1988 Matthew G. Maier.
All Rights Reserved.
^N:42




FLAG Db DoubleCheck Version 6 Up and Running
_________________________________________________________________



which FLAG will use in determining which records
to even bother checking. The general guidelines
for the use of the FLGFLT DOS environment variable
are outlined below.


FLAG6

Some of you may wish to use exPanded memory for
index buffering. As mentioned previously, I have
disabled FLAG's default use of exPanded memory to
avoid possible problems with some exPanded memory
managers and/or specifications. If you would like
to use exPanded memory, place the following state-
ment in your AUTOEXEC.BAT file, (or enter at your
system prompt).

SET FLAG6=R016;E0000;

Replace the '0000' after the 'E' with the amount
of exPanded memory you would like FLAG to use.

In addition, for those of you who do not have
exPanded memory, there is one other setting that
you can experiment with to achieve maximum perfor-
mance. This is the 'R' setting, the syntax for
the 'R' setting is the same as for the 'E' setting
above. The 'R' setting will determine how much of
conventional memory FLAG will use for index buff-
ering. Depending on total system RAM available
and the system itself you can fine tune the speed
with which FLAG will read and check you data file.


FLGFLT

This is a nice feature to have and thanks go to
John V. Parker for suggesting (requesting) I pro-
vide this ability. FLGFLT's intended use is to
EXCLUDE certain records that you may know you do
not want included in a check. For example, lets
say you did not want to check any records that had
a blank address. (assuming you have a .DBF with a
field called ADDRESS in it, naturally.) You would
put the following statement in your autoexec.bat,
a batch file that calls FLAG, or type it at the
DOS prompt prior to running FLAG.


_________________________________________________________________
R.1.0.1 23-Jul-1990
Copyright 1988 Matthew G. Maier.
All Rights Reserved.
^N:42




FLAG Db DoubleCheck Version 6 Up and Running
_________________________________________________________________



SET FLGFLT=EMPTY(ADDRESS)

FLAG will then examine records prior to checking
to determine if they meet this criteria. If the
record does, it is skipped and another is tried.
This loop will continue until a record that DOES
NOT match the expression set in FLGFLT is found or
the end of the file is reached.

FLGFLT will support most dBASE III+ expressions.
The only constraint being that the expression must
return a LOGICAL. In the next revision of the
manual, and the new release of FLAG due out soon,
hopefully, I will go into more detail on the uses
of FLGFLT.

To illustrate a few examples:

SET FLGFLT="1" $ address .or. empty(address)

The above would skip all records that contain a 1
in the address or have an empty address.

An empty field
empty()

A certain value in a field
== Equal to
!= Not Equal to
$ Contains

.AND. and .NOT. are supported for the construction
of complex expressions.

Anyway that is the general idea. If you have
questions, please, don't hesitate to write, call,
or email me and ask.












_________________________________________________________________
R.1.0.1 23-Jul-1990
Copyright 1988 Matthew G. Maier.
All Rights Reserved.
^N:42




FLAG Db DoubleCheck Version 6 Up and Running
_________________________________________________________________



Starting:

To start FLAG, type "FLAG6", and any command line argu-
ments you require, at the DOS prompt.

Command line arguments:

FLAG will accept only three command line argum-
ents; -Fd:\path\, -N, and -A. Each
argument must be proceeded by a '-', (hyphen), and
separated by a space.

i.e.

FLAG6 -A -Fd:\path\

Instructs FLAG to use 'd:\path\' and go
into Automatic mode.


Command line argument(s) descriptions:


-F File argument.
syntax: <-F>[[d:]\path\]
desc.: The -F parameter instructs FLAG to use
. The drive (d:) and path
(\path\) designations are optional.

-N Non-Stop mode
syntax: <-N>
desc.: If the -N argument is found on the com-
mand line, FLAG will start checking the
last file processed immediately upon
startup, provided the configuration
information is accurate and in-tact.

-A Automatic mode
syntax: <-A>
desc.: The -A argument tells FLAG to, fall,
from section to section; not stopping at
the main menu, you can press [ESC] to
abort this process from any menu.

NOTE: The -A and -N arguments cannot be used
simultaneously; the -N argument will not
be valid if the -F argument was used.


_________________________________________________________________
R.1.0.1 23-Jul-1990
Copyright 1988 Matthew G. Maier.
All Rights Reserved.
^N:42




FLAG Db DoubleCheck Version 6 Up and Running
_________________________________________________________________



After typing in the appropriate command line at the DOS prompt
you will see the opening screen. If you have an UNREGISTERED
version of FLAG you will see the shareware notice and will be
required to press the 'F5' function key before further execution
is possible. FLAG's main menu, if you have not specified the -A
command line argument, will now come up.


Main menu:

FLAG's main menu consists of six choices.

Data File Selection
Field Selection
Number of Checks
Options/Setup
Start Checking
Return to DOS


Navigation:

Highlight your selection with the cursor keys and press
[ENTER] to confirm your choice. Alternately, you can press
the first letter of your desired choice to make the selec-
tion. Select 'Return to DOS' and press [ENTER], press 'R',
or press [ESC] to abort and return to the operating system.


Description(s):

Data File Selection:

In this section you will be able to select a file to
check; from a list of the files in the current directo-
ry; type in a filename; specify a new filespec to use
in the pick window; type in the name of a file to
check; change directories; or change drives.

Field Selection:

This section is where you will specify which fields in
the selected file you would like to use in the checking
process.





_________________________________________________________________
R.1.0.1 23-Jul-1990
Copyright 1988 Matthew G. Maier.
All Rights Reserved.
^N:42




FLAG Db DoubleCheck Version 6 Up and Running
_________________________________________________________________



Number of Checks:

Where to start checking and the number of checks to be
done on each field are set from this section.

Options / Setup:

Toggle FLAG's options for checking; set the duplication
level(s); choose which field(s), if any, to include in
the report(s); set display of statistics; etc.

Start Checking:

Start the check process on the currently selected file
with the current setup.

Quit to DOS:

Leave FLAG and return to your normal operating environ-
ment (DOS).





























_________________________________________________________________
R.1.0.1 23-Jul-1990
Copyright 1988 Matthew G. Maier.
All Rights Reserved.
^N:42




FLAG Db DoubleCheck Version 6 File Selection
_________________________________________________________________



Section Title: Data File Selection


Description:

In the Data File Selection Menu you will select a file to
check, there are six options in this section:

Pick a file
Type in name
New File Spec
Change directory
Drive change
Quit/Return


Navigation:

Highlight your selection with the cursor keys and press
[ENTER] to confirm your choice. Alternately, you can press
the first letter of your desired choice to make the selec-
tion. Select 'Quit/Return' and press [ENTER], press 'Q', or
press [ESC] to abort.



Menu item descriptions:


Pick a file

Display a list of files in the current directory, that
match the filespec in the current configuration, and
choose one to check.

Highlight your selection with the cursor keys and press
[ENTER] to confirm your choice. Alternately, you can
press the first letter of your desired choice to make
the selection. Press [ESC] to abort.


Type in name

Type the name of a file you would like to check. Any
legal DOS filename is acceptable. If the file is not
in the current directory then you must include the
drive and directory designations. The file extension
is optional. FLAG will assume an extension of ".DBF"

_________________________________________________________________
R.1.0.1 23-Jul-1990
Copyright 1988 Matthew G. Maier.
All Rights Reserved.
^N:42




FLAG Db DoubleCheck Version 6 File Selection
_________________________________________________________________



and append it to the end of any filename given without
an extension.

NOTE: If you would like to check a file that does
not have an extension you must include a
period ('.') following the file's name. So
that FLAG will not automatically append ".-
DBF" to the end of the filename.

Type in filename and press [ENTER] to confirm. Press [ESC]
to abort.


New File Spec

Change the current filespec in the configuration file.
This file specification is used in determining which
files you see when you select the 'Pick a file' option
from the 'Data File Selection' menu.

Type in any valid DOS filespec and press [ENTER] to
confirm. Press [ESC] to abort.


Change directory

Change the current directory by choosing from a list of
the directories on the current disk drive.

Highlight the directory you wish to change to and press
[F10] to confirm. Press [ENTER] to see a list of the
subdirectories below the highlighted directory. Press
[ESC] to abort.


Drive change

Change the currently logged drive. Pick from a list of
the valid drives FLAG found on your system. FLAG will
check to insure the drive is ready and available.

Highlight the letter of the drive you wish to change to
with the cursor keys, or press the drive letter, and
press [ENTER] to confirm. Press [ESC] to abort.





_________________________________________________________________
R.1.0.1 23-Jul-1990
Copyright 1988 Matthew G. Maier.
All Rights Reserved.
^N:42




FLAG Db DoubleCheck Version 6 File Selection
_________________________________________________________________



Quit

Return to the main menu......



NOTE: FLAG will check the file picked, or typed, to determine
if it is dBASE III+ compatible or not. If the file is
NOT dBASE III+ compatible, or can NOT be USEd, you will
be notified.







































_________________________________________________________________
R.1.0.1 23-Jul-1990
Copyright 1988 Matthew G. Maier.
All Rights Reserved.
^N:42




FLAG Db DoubleCheck Version 6 Field Selection
_________________________________________________________________



Section title: Field Selection

Description:

Here you will be able to mark all of the fields you wish to use
in the check process. You can mark from one to all of the fields
in the table.

NOTE: All fields with a length of ZERO or of type Memo
will NOT be presented for selection. In addition there
are a few conditions pertaining to the amount of fields
you can check.

One, the overall length of all of the combined field
lengths must be less than 250 characters.

Two, the index expression cannot exceed 256 characters.
This will only become a problem if you want to check
lots and lots of fields or you are checking lots of
fields of type other than character.


Navigation:

Highlight your selection with the cursor keys, or press the
first letter of your desired choice, and press [ENTER] to
make your selection. Press [F10] to confirm ALL of your
choices. Press [ESC] to abort.


Instructions:

Whenever you mark a field FLAG will place a check mark next
to the field name in the selection window, so you know that
field is selected. In addition, FLAG will also display a
box on the bottom portion of the screen entitled 'Fields
Selected to Check'. This box will contain most, if not all,
of the fields marked to check, two lines worth.

On the right side of the screen the 'Index Lengths' box will
contain two statistics that you will need to keep an eye on,
Expression and Check Key.

Expression: The length of the command that will be
required to index your file, this number
needs to be lower than 256.



_________________________________________________________________
R.1.0.1 23-Jul-1990
Copyright 1988 Matthew G. Maier.
All Rights Reserved.
^N:42




FLAG Db DoubleCheck Version 6 Field Selection
_________________________________________________________________



Check Key: The combined lengths of the fields you
have selected to check. This number
needs to be lower than 250. Preferably
around 200, if you are going to check
many fields. In most cases this does
not present a problem. But if you are
checking numerous fields, or fields
whose lengths are very long, you will
need to watch this number.



NOTE: Deselecting fields:

Position the highlight over a selected field name and
press [ENTER]. The check mark will be removed from
beside the field name, and the field name will no
longer appear in the list at the bottom of the screen,
and the Expression and Check Key will be adjusted
accordingly.


NOTE: Accepting your choices:

After you have selected all of the fields that you wish
to check and pressed [F10] to confirm your selections.
FLAG will automatically make an estimate of how much
disk space is needed, to build the required index file,
and compare that to what is available. If there is not
enough disk space you will be notified and returned to
the main menu.

What you will need to do now is either
quit or select 'Data File Selection'
from the main menu. When you are in the
'Data File Selection' section select the
'Drive change' option. After you have
changed to a different drive, select the
'Field Selection' option again, verify
that the fields you want to check are
marked and then press [F10].









_________________________________________________________________
R.1.0.1 23-Jul-1990
Copyright 1988 Matthew G. Maier.
All Rights Reserved.
^N:42




FLAG Db DoubleCheck Version 6 Number of Checks
_________________________________________________________________



Section title: Number of Checks

Description:

In this section you will designate what to check in each of
the field(s) selected. You can tell FLAG where and how much
of a field to check.

Navigation:

Highlight your selection with the cursor keys, or press the
first letter of the field name, and press [ENTER] to select.
Press [F10] to confirm ALL of your changes. Press [ESC] to
abort.

Instructions:

When you select a field name from the selection box you will
be prompted to input two values. One to tell FLAG where to
start checking within the field and the other tells FLAG how
much of the field to check. The valid ranges for these two
values will be displayed along with the prompts. The de-
faults that FLAG sets for you when you select fields from
the 'Fields Selection' main menu option are:

Starting position - 1
Number of checks - 4

(In most cases. Although, if the field length is less
than 4, the number of checks will be the length of the
field instead.)


















_________________________________________________________________
R.1.0.1 23-Jul-1990
Copyright 1988 Matthew G. Maier.
All Rights Reserved.
^N:42




FLAG Db DoubleCheck Version 6 Options Section
_________________________________________________________________



Section title: Options / Setup

Description:


This section allows you to customize the check process to suit
your needs. By means of a series of toggles, prompts, and multi-
ple choice options.


Navigation:

Highlight your selection with the cursor keys, or press the
first letter of your desired option, and press [ENTER] to
select/toggle your choice. Press [F10] to confirm ALL of
your selections. Press [ESC] to abort.


Instructions:

In most cases all you will need to do is highlight the op-
tion and press [ENTER] to toggle between ON and OFF sett-
ings. There are two other options that are NOT toggles
though, for these you will need to input information or make
selections.

Set HI and LO duplication levels:

When this option is selected you will be prompted for
duplication settings for Exact, Probable, and Possible
levels. In addition, you can tell FLAG whether or not
to include each of these levels in any reports being
generated. (see option description for more details)

Pick fields to use in report(s).

When you select this option you will be presented with
the same list of fields that you saw in the 'Field
Selection' section of the main menu. You may pick as
many fields as you would like, just make sure you have
wide enough paper. (see option description for more
details)








_________________________________________________________________
R.1.0.1 23-Jul-1990
Copyright 1988 Matthew G. Maier.
All Rights Reserved.
^N:42




FLAG Db DoubleCheck Version 6 Options Section
_________________________________________________________________



Sample layout of Option Descriptions:


Option number
----------------------------------------

Name of Option

ON -- Action if parameter is on
OFF-- Action if parameter is off

A longer explanation and/or an example.

----------------------------------------



































_________________________________________________________________
R.1.0.1 23-Jul-1990
Copyright 1988 Matthew G. Maier.
All Rights Reserved.
^N:42




FLAG Db DoubleCheck Version 6 Options Section
_________________________________________________________________



1
----------------------------------------

Ignore Character Case

ON -- The case, upper or lower, of a character IS ignored
OFF-- The case of a character IS NOT ignored

If you turn this parameter ON then all letters will be trea-
ted equally. Meaning, as one case, not as mixed case where
an upper case 'J' is not the same as a lower case 'j'. This
is good for names, addresses, etc. that do not require case
sensitivity for uniqueness.

i.e.

data in the table looks like:

field1 field2
record1 J JOnes 1122 ANy St
record2 J Jones 1122 Any St

With Option ON:

record1 J JONES 1122 ANY ST
record2 J JONES 1122 ANY ST

----------------------------------------





















_________________________________________________________________
R.1.0.1 23-Jul-1990
Copyright 1988 Matthew G. Maier.
All Rights Reserved.
^N:42




FLAG Db DoubleCheck Version 6 Options Section
_________________________________________________________________



2
----------------------------------------

Ignore ALL spaces when checking

ON -- Matching spaces ARE NOT counted
OFF-- Matching spaces ARE counted

Normally FLAG will count spaces as matches if they occur, in
the same place, in the same field, in both records. You can
override this by turning this option ON. Telling FLAG that
spaces are not important and not to count them.

FLAG will then extract all of the spaces from the field(s)
as they are to be checked. FLAG will try to extract a val-
id, no spaces, string that is equal to the number of checks
specified. The extraction will continue until either the
correct number of characters are found, or the end of the
field is reached. If FLAG searched until the end of the
field, the remaining unfilled character places will be re-
placed with a special character. When FLAG reaches this
special character during the check of the field it will
terminate that particular check and go on to the next.

i.e. (start checking at character 1, with a length of 5)

data in table looks like FLAG sees this

field1 field2 field1 field2
record1 J Jones 1122Any St J Jon 1122A
record2 JJones 1122 Any St JJone 1122
||||| |||||
With Option ON: 12345 12345
||||| |||||
record1 J Jones 1122Any St JJone 1122A
record2 JJones 1122 Any St JJone 1122A


NOTE: Keep in mind that FLAG does this extraction dynamical-
ly, meaning for _every_ field to be checked in _every_
record. While this does yield a substantially improved
check it will in turn reduce the speed of the check.

----------------------------------------





_________________________________________________________________
R.1.0.1 23-Jul-1990
Copyright 1988 Matthew G. Maier.
All Rights Reserved.
^N:42




FLAG Db DoubleCheck Version 6 Options Section
_________________________________________________________________



3
________________________________________

Ignore ALL punctuation characters while checking

ON -- Punctuation characters IS NOT counted
OFF-- Punctuation characters ARE counted

Normally FLAG will count punctuation characters as unique.
Punctuation is one place where mistakes are most common.
This along with different abbreviation practices can lead to
data that will not show up as being an even close match yet
it is. FLAG now has the option of ignoring punctuation
characters. Turning this option ON will instruct FLAG to
take out any punctuation it finds and not include it in the
check.

FLAG will then extract all of the punctuation characters
from the field(s) as they are to be checked. FLAG will try
to extract a valid, no punctuation, string that is equal to
the number of checks specified. The extraction will contin-
ue until either the correct number of characters are found,
or the end of the field is reached. If FLAG searched until
the end of the field, the remaining unfilled character
places will be replaced with a special character. When FLAG
reaches this special character during the check of the field
it will terminate that particular check and go on to the
next. (This may sometimes cause 'strange' behavior with
regard to what will then be considered a duplicate. This is
caused by FLAG not having enough characters to check, and
not being able to check these special characters we have
determined are to be stripped out. This behavior is even
more evident when spaces are ignored. I am currently working
on a new approach that will alleviate this problem)

Example:

Field contents FLAG will see

122 W. 5th St. 122 W 5th St
122 W 5th St 122 W 5th St








_________________________________________________________________
R.1.0.1 23-Jul-1990
Copyright 1988 Matthew G. Maier.
All Rights Reserved.
^N:42




FLAG Db DoubleCheck Version 6 Options Section
_________________________________________________________________



4
----------------------------------------

Write report to a file

ON -- Write all duplicates found to a file
OFF-- DO NOT write all duplicates found to a file

You supply the name of the file to create, up to 225 charac-
ters with drive and path designation. There are a few thi-
ngs to consider when choosing this option:

One, you will need to make sure there is enough room on
the disk to create the file. I cannot estimate how
large the file will be ahead of time due to the fact
that FLAG may find no duplicates or it may find hun-
dreds.


Two, this is mostly for the multi-user environment, you
will need to make sure you have CREATE and WRITE rights
in the directory where you would like to create the
file.

----------------------------------------

























_________________________________________________________________
R.1.0.1 23-Jul-1990
Copyright 1988 Matthew G. Maier.
All Rights Reserved.
^N:42




FLAG Db DoubleCheck Version 6 Options Section
_________________________________________________________________



5
----------------------------------------

Print report to printer

ON -- The doubles found WILL be sent to the printer
OFF-- The doubles found WILL NOT be sent to the printer

With this parameter ON any duplicates that are found, and
whose level has been turned ON for printing, will be sent to
the printer.

FLAG will also include some statistics with each record,
(record numbers; whether it was an exact, a probable, or a
possible duplicate; how many matches [how many of the checks
you designated were hit]). FLAG will also place the time
and date at the top of each page along with the name of the
file being checked, the field(s) checked, and headers for
the column(s). At the bottom will be the total number of
checks being done and counts of exact, probable, possible,
total duplicates found.

The 'printer' here is LPT1, or the default PARALLEL port on
your computer. If you have a printer hooked up to a serial
port you will need to use the DOS MODE command to redirect
LPT1 to COMx (where x is the number of the serial port you
have your printer hooked up to).

The miscellaneous information on the report will follow this
template:

File name:
Field names:
Date: Time: Page #
===========================================================
DL/H | Record # | Field heading(s)...
===========================================================
Prob 99999999
9999 99999999

DL = Duplication Level:
EXCT = Exact
Prob = Probable
Poss = Possible

H = Number of hits on this comparison

----------------------------------------

_________________________________________________________________
R.1.0.1 23-Jul-1990
Copyright 1988 Matthew G. Maier.
All Rights Reserved.
^N:42




FLAG Db DoubleCheck Version 6 Options Section
_________________________________________________________________



6
----------------------------------------

Print Statistics to printer

Print the statistics of the check to the printer. This
option will print the end of check statistics to the same
printer as the report, if the report option was enabled.
These statistics include:

The name of the file checked
The time and date checked
The fields with number of checks done on each field
The total amount of checks
The number of records to check
The number of records checked
A detail of how much of each duplicate level was detected by
FLAG, and how many, if any, records were marked.

----------------------------------------





























_________________________________________________________________
R.1.0.1 23-Jul-1990
Copyright 1988 Matthew G. Maier.
All Rights Reserved.
^N:42




FLAG Db DoubleCheck Version 6 Options Section
_________________________________________________________________



7
----------------------------------------

Print with Graphics characters

This option enables FLAG to use the extended ASCII graphics
characters in its printouts. Some printers do not support
these extended characters and will print odd replacement
characters.

If you see a double lined box below, then your printer sup-
ports the extended ASCII character set and you can turn this
option ON if you wish to. If not, then you should leave this
option OFF for proper printouts.





----------------------------------------





























_________________________________________________________________
R.1.0.1 23-Jul-1990
Copyright 1988 Matthew G. Maier.
All Rights Reserved.
^N:42




FLAG Db DoubleCheck Version 6 Options Section
_________________________________________________________________



8
----------------------------------------

Show Statistics while checking

ON -- Show progress on screen
OFF-- Do not show any statistics on screen

If this parameter is ON then statistics will be shown on the
screen. These will include:

Time: Started, Current, and Elapsed
Filename and field name(s)
Number of records to check and the number done
Which records are being checked (compared)
Total number of checks to do
Number of hits on current check (comparison)
Counts and percentages of duplicates found for:
exact
probable
possible
total
Option indicators for:
Reports:
print
file (if on, the name of the file)
graphics
Marking of Exact duplicates found
Graphical percentage done indicator

The check will go slightly slower when displaying the sta-
tistics, but it is useful information. If leave this param-
eter OFF then you will be shown a message indicating that
FLAG is processing xxxx file, a running count of the number
done, and an elapsed time indicator.

NOTE: You can press [F10] while FLAG is
running to switch between these two displays,
additionally you can press [ESC] to abort
FLAG during the check process.

----------------------------------------







_________________________________________________________________
R.1.0.1 23-Jul-1990
Copyright 1988 Matthew G. Maier.
All Rights Reserved.
^N:42




FLAG Db DoubleCheck Version 6 Options Section
_________________________________________________________________



9
----------------------------------------

Mark EXACT duplicates during check

ON -- Mare EXACT duplicates for deletion
OFF-- DO NOT mark EXACT duplicates found

If you turn this option ON then records that are found to be
EXACT AND ONLY EXACT, meaning every check on every field
selected was a hit, will be marked.

As they would be in dBASE III+ if you BROWSED a file and
pressed [CTRL-U]. This DOES NOT mean the record is physi-
cally DELETED, it is only marked for deletion in the same
manner that dBASE marks a record for deletion. You would
still have to go into dBASE, USE the file and PACK the file
in order to literally DELETE the marked records. You can
also retrieve, UNMARK, all of the marked records by, again,
starting dBASE, USEing the file, and issuing the command
RECALL ALL from the dot prompt.

----------------------------------------


























_________________________________________________________________
R.1.0.1 23-Jul-1990
Copyright 1988 Matthew G. Maier.
All Rights Reserved.
^N:42




FLAG Db DoubleCheck Version 6 Options Section
_________________________________________________________________



10
----------------------------------------

Set HI and LO duplicate levels

This option will present you with a list of the different dupli-
cate levels that FLAG supports. You will be able to indicate to
FLAG how many hits need to be made during the check, on each
record in order to qualify as one of these duplicate levels. In
addition you will be able to tell FLAG which, if any, duplicate
levels to include in any report(s). Placing a 'N' in the print
field will tell FLAG NOT to include any records found that match
this level of duplication.

Each level of duplication has a HI and LO setting, except for
EXACT which only has a low (the exact HI setting is always the
total number of checks being done).

Designating levels:

EXACT LO -- This number must be less than or equal
to the total number of checks being
made, and greater than the Probable HI
setting.

Probable HI -- This setting must be less than the EXACT
LO setting, and greater than or equal to
the Probable LO setting.

Probable LO -- This setting must be less than or equal
to the Probable HI setting, and greater
than the Possible HI setting.

Possible HI -- This setting must be less than the Prob-
able LO setting, and greater than or
equal to the Possible LO setting.

Possible LO -- This setting must be greater than ZERO,
and less than or equal to the Possible
HI setting.

All of the settings are dynamically updated by means of cascad-
ing. So, if you change the EXACT LO setting to be lower than the
Probable HI setting then all other settings will be changed, as
needed, to conform the above conditions.

----------------------------------------


_________________________________________________________________
R.1.0.1 23-Jul-1990
Copyright 1988 Matthew G. Maier.
All Rights Reserved.
^N:42




FLAG Db DoubleCheck Version 6 Options Section
_________________________________________________________________



11
----------------------------------------

Pick fields to use in report(s)

Selecting this option will pop up a list of the fields in the
file you selected to check. You will then be able to select
which field(s) to include in the report(s). By positioning the
highlight bar with the cursor keys, or pressing the first letter
of the field name, and then pressing [ENTER] you will select that
field to be included in any report. After you are finished press
[F10] to confirm ALL of your selections and return to the options
menu. Pressing [ESC] will abort back to the options menu.

FLAG will calculate the amount of space needed to print the
report for you and display it on the left side of the screen.
This 'Page Width' number is how many spaces you will need in
order to print the requested field(s).

FLAG reserves the first 23 character spaces for:

left margin: 5
level/hits: 7
record #: 11
Total:23 spaces

----------------------------------------






















_________________________________________________________________
R.1.0.1 23-Jul-1990
Copyright 1988 Matthew G. Maier.
All Rights Reserved.
^N:42




FLAG Db DoubleCheck Version 6 Appendix A
_________________________________________________________________



APPENDIX A -- Hints


Picking Data Files


Any table being checked must be dBASE III+ compatible.

FLAG will not check a data file with less than 10 records in it,
that sized table should not need automated checking.

Be sure the data file is up to date, that any additions have
already been made to it, and so on. There is little use in
running a thorough check of a file, update it, and run the check
again.


Picking fields

Try to pick a combination of fields that will present FLAG with
the fullest possible picture of your data, without being exclu-
sively unique or redundant.

Any 'generated' primary key, by primary key I mean what you
uniquely identify each record with (i.e. an id number, part
number, series of letters, etc.), is not a good idea, but if the
primary key is manually entered, or is composed of the raw data
being entered then it is a prime candidate for FLAG to check.

Remember not to go overboard on uniqueness either. If what you
decide to check is overly unique FLAG will find few, if any,
duplicates.

The goal is to select the right amount of fields, and data in the
fields, to present FLAG as complete a picture of what your ta-
ble's theme, entity, without over burdening FLAG with too many
checks to process.

For instance:

If your table is based upon the entity Customer, then the
name and street address are pretty good choices to check.
Why? Well, the last name is definitely NOT unique in most
cases. While the combination of first+last names is slightly
more unique it still provides too wide a margin for error.
But, with the addition of the street address, the key com-
posed of first name, last name, and street you get a pretty
fair representation of what the whole table is about.

_________________________________________________________________
R.1.0.1 23-Jul-1990
Copyright 1988 Matthew G. Maier.
All Rights Reserved.
^N:42




FLAG Db DoubleCheck Version 6 Appendix A
_________________________________________________________________



What is needed is a good combination of fields that will give
FLAG a good representation of the data in the table through a
carefully selected sample. The fields chosen should be as unique
as possible. Meaning, fields like zip codes, states, and some-
times city will not be unique enough to generate an accurate
duplication estimate. Fields like names, streets, phone numbers,
etc. will produce the best results. These fields will provide
FLAG with a key that gives a very good representation of the
information contained within the record and yet the key is not so
unique as to not generate any duplicates.



Number of checks to do

This is really pretty much based upon the amount of repetition in
each of the fields you choose to check. With fields such as
names or streets you would want to make the number of checks
large enough to get past the part of the field that is likely to
be similar in a large percentage of records.

With version 6 you can now start checking deeper within the
fields so the check length can remain smaller. With a field like
street address. For example, there are likely to be many records
with the first portion of the address, the digits, that will be
exact or very similar. So, to circumvent this, you would want to
designate a large enough check start value to get past the first
part of the address, the number, and get into the street name. A
portion of the street number combined with a portion of the
street name would give an optimal check of a field such as ad-
dress.

But in fields like city the first three or four characters will
generally be sufficiently unique. (This, of course, will depend
upon the range or your address list. If all of your addresses
are in one state then the cities in that state have a high like-
lihood of being redundant and would therefore not be a good
choice to include in the check.)











_________________________________________________________________
R.1.0.1 23-Jul-1990
Copyright 1988 Matthew G. Maier.
All Rights Reserved.
^N:42




FLAG Db DoubleCheck Version 6 Appendix B
_________________________________________________________________



APPENDIX B -- History


I first wrote FLAG in 1988. It was coded in dBASE III+ and ran
pretty darn slow, after I made a few enhancements even slower.

In 1989 FLAG was compiled with Clipper Summer '87 and became FLAG
Db DoubleCheck. Since then I have made many enhancements and
changes to the original FLAG, taking advantage of the Clipper
language.

FLAG Db DoubleCheck keeps getting better and better. In the
future the memory requirements for FLAG Db DoubleCheck will be
reduced substantially making it possible for me to add more
flexibility and enhance more of the features.


Revision History by Version

Version 6

R.1.9.2
- Implemented ignore punctuation option. I was saving
this for the new release but figured what the heck.
- Worked on the checking a little more and have fixed
something that some of you may have run into. A prob-
lem where you knew there were mixed case characters and
they were not showing up in the check even with ignore
case on. Well, that won't happen anymore.
- Finally implemented the environment variable support
that I intended to do awhile back. The new environment
variable "FLGFLT" supports record filtering expres-
sions.

R.1.8.1
- Revs 1.x.x - 1.8.1 were minor changes that I have made
along the line. None of which are worth mentioning.
Most have to do with the an upcoming new release of
FLAG and new versions of the compilers I use in FLAG's
development.
- Minor fixes to certain internals in the checking sec-
tion, re-engineered the string handling for ignoring
spaces and case.
- FLAG was not saving configurations correctly.
- Amount of area printed on each page has been condensed
so that printers set up to print 60 lpm will not print
a blank page for every full one.


_________________________________________________________________
R.1.0.1 23-Jul-1990
Copyright 1988 Matthew G. Maier.
All Rights Reserved.
^N:42




FLAG Db DoubleCheck Version 6 Appendix B
_________________________________________________________________



- FLAG now knows exactly (within reason, standard errors)
what is wrong with your printer. (i.e. offline, not
selected, out of paper, not on, etc.)

R.1.0.1
- Corrected FLAG's inability to accept and use the drive
correction if the data files were not in the current
directory.
- Added ability to print or pause to view the statistics
shown on the screen at the end of a check.
- Fixed problem while marking duplicates found, when the
mark duplicate option was toggled ON.
- Rewrote ignore space and check routines in C, this
makes these two specific routines much faster.

R.1.0.0
- Added configuration and history files.
- Will now ignore ALL spaces not just matching ones.
- Fields for report can now be picked.
- Redesigned menus.
- Enabled [ESC] to abort from all menus and data entry
prompts.
- Added command line arguments.
- Settings for duplication levels added.
- Report toggles for duplication levels.
- Broke report into two separate pieces so a check can be
run and ONLY statistics get printed (good for writing a
report to a file and just printing statistics at the
end).


Version 5

R.0.3.0
- Condensed/Optimize checking procedure
- FLAG no longer has problems with ExPanded memory
- Opening screen delays eliminated

R.0.2.8
- Fixed internal problem with network compatibility.
- FLAG was not recognizing that it had USEd a table, it
now does what it should.
- Added graphic/non-graphic character printing option.
R.0.2.0
- Added watch for index key and expression lengths.
- Fixed problem with numeric field conversions in the
index expression during indexing and checking.


_________________________________________________________________
R.1.0.1 23-Jul-1990
Copyright 1988 Matthew G. Maier.
All Rights Reserved.
^N:42




FLAG Db DoubleCheck Version 6 Appendix B
_________________________________________________________________



- Added abort back to main menu from the field selection
and number of checks section with left and right cursor
movement keys.
- Added recognition of a 'table in use by another user'
for networks.

R.0.1.3
- Statistics added to the end of text file.
- Allowed ESCape to abort back to main menu from certain
menus.

R.0.1.0
- Fixed a problem that occurred when there were less than
three fields selected for checking.



































_________________________________________________________________
R.1.0.1 23-Jul-1990
Copyright 1988 Matthew G. Maier.
All Rights Reserved.
^N:42




FLAG Db DoubleCheck Version 6 Appendix C
_________________________________________________________________



APPENDIX C

Technical Support / Author


Any and all comments are welcome. I can be reached in any of the
following ways:


US Mail:

Matthew G. Maier
19019 Capehart Drive
Gaithersburg, MD 20879


Telephone: (301)869-1879

Hours - Weekday: 8:00 am EST/EDT - 9:00 pm EST/EDT
(Leave a message with a phone number
where you can be reached after 9:00 pm
EST/EDT or during the day.)

Hours - Weekend: 11:00 am EST/EDT - 10:30 pm EST/EDT
(Generally, I am in and out all weekend
long, so leave a message if I am not in
at the time.)


Email

If at all possible please use Email, it is considerably
easier to communicate via Electronic Mail. It is both
faster, and more easily controlled. Thank you for your
cooperation.

CompuServe: 76370,743
75140,1627
GEnie: M.MAIER1
M.MAIER
In the DBMS RoundTable (page 485)

If one of the above IDs does not generate a response please
try one of the others. I try to check my mail in all of the
accounts each day but you know how things can get at times




_________________________________________________________________
R.1.0.1 23-Jul-1990
Copyright 1988 Matthew G. Maier.
All Rights Reserved.
^N:42




FLAG Db DoubleCheck Version 6 Appendix C
_________________________________________________________________



BBS:

I can be reached via InterLink in the Clipper conference.
IDBUG BBS in the public section (long distance, so I do not
check in very often)
Several local BBSs around the MD/DC/VA area.


Generally, calling my house will get the best results. After that
it is a toss-up between CompuServe and GEnie. So have faith, I
will respond to ALL email, phone calls, letters, etc.







































_________________________________________________________________
R.1.0.1 23-Jul-1990
Copyright 1988 Matthew G. Maier.
All Rights Reserved.
^N:42




FLAG Db DoubleCheck Version 6 Appendix D
_________________________________________________________________



APPENDIX D -- Quick Reference


Remember: [ESC] to ABORT



File Selection:

Pick a file: Pick from a list of files in the current
directory. Press [ENTER] to select.

Type in name: Enter any valid DOS filename.

Change File Spec: Enter a valid DOS filespec.

Change directory: Pick from directories on the current
drive, press [ENTER] to view subdirec-
tories of the highlighted directory.
Press [F10] when finished.

Drive change: Pick from a list of valid drives.

Quit: Return to the Main Menu.



Field Selection:

Select/Deselect: Choose from list of fields in current
file. [ENTER] to select/deselect, [F10]
when finished.



Number of Checks:

Changing checks: Select field from list, press [ENTER] to
edit check start and length. Press
[F10] when finished.

Check Start: Where in the field to start checking.
Enter a value greater than 1 and less
than the total field length minus the
amount of checks to do.




_________________________________________________________________
R.1.0.1 23-Jul-1990
Copyright 1988 Matthew G. Maier.
All Rights Reserved.
^N:42




FLAG Db DoubleCheck Version 6 Appendix D
_________________________________________________________________



Check Length: How much of field to check. Enter a
value greater than 1 and less than the
total field length minus the check
start.



Options / Setup Section:

Toggle/Select: Highlight option press [ENTER] to tog-
gle. Press [F10] when finished.



Start Checking:

During check: Press [F10] to switch between showing
and not showing statistics on screen.































_________________________________________________________________
R.1.0.1 23-Jul-1990
Copyright 1988 Matthew G. Maier.
All Rights Reserved.
^N:42




FLAG Db DoubleCheck Version 6 ASP
_________________________________________________________________



APPENDIX E -- ASP - Ombudsman


The Association of Shareware Professionals (ASP) -- Ombudsman


This program is produced by a member of the Association of Share-
ware Professionals (ASP). ASP wants to make sure that the share-
ware principle works for you. If you are unable to resolve a
shareware-related problem with an ASP member by contacting the
member directly, ASP may be able to help. The ASP Ombudsman can
help you resolve a dispute or problem with an ASP member, but
does not provide technical support for members' products. Please
write to the ASP Ombudsman at P.O. Box 5786, Bellevue, WA 98006
or send a CompuServe message via easyplex to ASP Ombudsman
70007,3536.

































_________________________________________________________________
R.1.0.1 23-Jul-1990
Copyright 1988 Matthew G. Maier.
All Rights Reserved.
^N:42




FLAG Db DoubleCheck Version 6 Registration
_________________________________________________________________



APPENDIX F -- Registration


Name: _______________________________________________________

Address: _______________________________________________________

_______________________________________________________

City: _______________________________________________________

St/Prov: ______________________________ Zip: ______________

Country if not United States: __________________________________

Phone: ______________________________ Date: ______________

Email: CompuServe____________________ GEnie________________

============================================================
Qty. Product description Price Total
____________________________________________________________
| FLAG Db DoubleCheck V6.1.9.2 | $22.95 |
____________________________________________________________
Shipping and Handling| $ 2.50
MD state residents add 5% state tax|
____________________________________________________________
Total enclosed|
============================================================

ALL order(s) must be accompanied by payment; no purchase order(s)
accepted; all monies in U.S. funds; check(s) drawn on U.S. banks,
or USPS certified money order(s).

Please make payment(s) payable to: Matthew G. Maier

Remit registration(s), accompanied with payment(s), to:

Matthew G. Maier
19019 Capehart Drive
Gaithersburg MD 20879

Comments:






_________________________________________________________________
R.1.0.1 23-Jul-1990
Copyright 1988 Matthew G. Maier.
All Rights Reserved.
^N:42




FLAG Db DoubleCheck Version 6 Registration
_________________________________________________________________



Pricing, Site License, and discount rate chart (per registration)


1 - 10 . . . . . . . . . . . . . $ 22.95 ea.
11 - 20 . . . . . . . . . . . . . . 17.95
21 - 35 . . . . . . . . . . . . . . 12.95
36 - 100 . . . . . . . . . . . . . . . 7.95
101 - 500+ . . . . . . . . . . . . . . . 5.95
Site License . . . . . . . . . . . . . 1500.00

All orders include $ 2.50 Shipping/handling per order.






































_________________________________________________________________
R.1.0.1 23-Jul-1990
Copyright 1988 Matthew G. Maier.
All Rights Reserved.
^N:42




FLAG Db DoubleCheck Version 6 Thank you!
_________________________________________________________________
























Thank You!

for trying

FLAG Db DoubleCheck Version 6























_________________________________________________________________
R.1.0.1 23-Jul-1990
Copyright 1988 Matthew G. Maier.
All Rights Reserved.
^N:42