SP_LISTER

LISTER()

  Short:
  ------
  LISTER() Build, format,print SIMPLE lists to
  printer,screen,file

  Returns:
  --------
  Nothing

  Syntax:
  -------
  LISTER([aNames,aDesc])

  Description:
  ------------
  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
  wraparound.

  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
  for descriptions.

  Examples:
  ---------
   USE CUSTOMER

   LISTER()

  Source:
  -------
  S_LIST.PRG

 


 

SP_GLOBREP

GLOBREP()

  Short:
  ------
  GLOBREP() Performs global selective replace of a field

  Returns:
  --------
  Nothing

  Syntax:
  -------
  GLOBREP([aFields,aDesc])

  Description:
  ------------
  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
  descriptions.

  Examples:
  ---------
   If nChoice == 9   // Global replace

     GLOBREP()

   endif

  Warnings:
  ----------
  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.

  Source:
  -------
  S_GLOBR.PRG

 

SP_DUPHANDLE

DUPHANDLE()

  Short:
  ------
  DUPHANDLE() Duplicate record finder with delete/copy options

  Returns:
  --------
  Nil

  Syntax:
  -------
  DUPHANDLE([aFields,aDesc],[aOpenIndexes])

  Description:
  ------------
  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
  delete them.

  As with all SuperLib deletions, the PACKING is left
  to you.

  [aFields,aDesc] are optional arrays of fieldnames and
  field descriptions

  [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.

  Examples:
  ---------

  USE customer

  duphandle()

  Warnings:
  ----------
  Closes all indexes.

  Source:
  -------
  S_DUPH.PRG