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 v6.11 - aofgetrecord() http://www.X-Hacker.org [<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]
 aofGetRecord()
 Returns the record number currently positioned to in the Advantage
 Optimized Filter
------------------------------------------------------------------------------

Syntax

     aofGetRecord( <nHandle> ) -> numeric

     <nHandle>  Handle to an existing filter.

Returns

     Returns the numeric record number to which the specified filter is
     currently positioned.

Description

     aofGetRecord returns the record number to which the specified filter
     is currently positioned.  If the filter is a user-owned filter, then
     this record number may not be the same as the system's record number
     (which is obtained via the recno() function). It is possible to
     traverse a user-owned filter via the aofGoTop(), aofGoBottom(),
     aofGoRecord(), and aofSkip() functions. aofGetRecord() can be used
     to return the record number positioned to via these functions.

Example

     USE customer INDEX state

     nHandle := aofCreateFilter( "state = 'CA'" )

     aofGoTop( nHandle )
     ? aofGetRecord( nHandle )     // Will return record number of first
                                   // state in 'CA'

     aofSkip( nHandle )
     ? aofGetRecord( nHandle )     // Will return record number of second
                                   // state in 'CA'

     aofFreeFilter( nHandle )


See Also: aofGoTop() aofGoBottom() aofGoRecord() aofSkip()

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