[<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]
Function            DUPLOOK()
Action              Locates possible duplicates based on user criteria
Returns
Category            Metafunction
Syntax              DUPLOOK([expC])
Description         Searches current dbf for exact duplicates of
                    field(s) selected by user. User picks a field
                    or fields, DUPLOOK() creates an index and prepares
                    a possible duplicates report.

Options             <expC> Character expression as additional info for
                    each report line printed. (report normally only
                    refers to record# and the fields selected )

Examples            DUPLOOK("Lastname+'  '+Firstname")
                    * whatever fields the user picks to check duplicates
                    * on, the LASTNAME and FIRSTNAME fields are also
                    * printed on the report.

                    Sample Output:

                    Record #   FNAME
                        1      GARRY
                        2      GARRY

Warnings            THIS FUNCTION CLOSES ANY OPEN INDEXES.
                    YOU WILL NEED TO RE-OPEN INDEXES ON EXIT.

Warnings            Key -9 is unset on exit (F10), cursor is left ON
Found in (prg)......S_DUP.PRG

This page created by ng2html v1.05, the Norton guide to HTML conversion utility. Written by Dave Pearson