Retro video games delivered to your door every month!
Click above to get retro games delivered to your door ever month!
X-Hacker.org- Advantage CA-Clipper Guide v5.5 - ax_skipunique() http://www.X-Hacker.org [<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]
 AX_SkipUnique()
 Allows you to skip to the next/previous unique key in an index
------------------------------------------------------------------------------

 Syntax

    AX_SkipUnique( [<nDirection>] ) -> logical

     <nDirection> An optional numeric value indicating the direction to
     be skipped.  The default value is 1, and will skip ahead to the
     next greater key value.  A value of -1 will skip to the first key
     of lesser value in the index.

 Returns

     Returns a logical .T. if the operation was successful, else returns .F.
     If an error occurred, AX_Error() will return information on why the
     function failed.

 Description

     AX_SkipUnique() allows you to skip through a non-unique index
     order as if it had been created with the UNIQUE clause. This
     eliminates the need to have a full index and a UNIQUE index built
     on the same expression. For those cases, you can now use one index
     to handle both situations.

 Example

     USE test VIA "DBFNTXAX"
     INDEX ON state TO state

     // Display STATE field for ALL records
     GO TOP
     WHILE !eof()
        ? test->STATE
        dbSkip()
     END
     ?

     // Display unique STATE fields
     GO TOP
     WHILE !eof()
        ? test->STATE
        AX_SkipUnique()
     END


Online resources provided by: http://www.X-Hacker.org --- NG 2 HTML conversion by Dave Pearson