LISTER() Build, format,print SIMPLE lists to
A menu driven utility for creation, printing and
storage of list definitions.
The user is asked to pick the fields to be included
on the list. The selected fields, in the order in which
they will be listed, are shown in the bottom information box.
The user may select which records are to be included in the list -
all records, query matches or tagged records.
The user may select output as PRINTER, SCREEN or
FILE, and choose the maximum line length to avoid printer
The user may save list definitions to PLIST.DBF and
later restore them.
Two arrays may be passed - fieldnames [aNames], and
field descriptions [aDesc] Pass both or none. Normally, field
names are used as the column headings for the list, but if
[aDesc] is passed, these descriptions are used in the column
headings of corresponding fields.
By default, all fields are used, field names are used
GLOBREP() Performs global selective replace of a field
Allows user to point to a field and then enter a
replacement value for it. Replacement can be executed for all
records, query matches, or tagged records.
[aFields,aDesc] arrays of field names, and field
If nChoice == 9 // Global replace
These changes are, of course, permanent.
New to 3.5:
-Preview (view changes before they happen)
-'Build Formula' replacement option type. Lets user build a
formula for replacing the target field.
DUPHANDLE() Duplicate record finder with delete/copy options
DUPHANDLE() is similiar to DUPLOOK(), but takes a
different approach The user is asked to select fields (only
Character fields are presented) to check for duplication. The
fields selected are combined into an index key, and an index is
created. The database is then scanned for duplicates. If a
duplicate set is found, a Tbrowse/tag window is popped up, and
the user is asked to tag records. This continues until all
duplicate sets are found, or the user chooses to quit the
process. The user is then allowed to Process the tagged
duplicate records. There are 4 possible options:
Delete all tagged records
Delete all NOT tagged records
Copy all tagged records
Copy all NOT tagged records
The options are not mutually exclusive. For instance,
you could copy all tagged records to a history file, and then
As with all SuperLib deletions, the PACKING is left
[aFields,aDesc] are optional arrays of fieldnames and
[aOpenIndexes] is an optional array of currently open
index names. Clipper has no way to determine the names of
currently open indexes and, since this function creates
temporary indexes, the current indexes will be closed. Only by
having a list [aOpenIndexes] can we re-open the indexes on exit.
Closes all indexes.