Click above to get retro games delivered to your door ever month!

 ORDFOR() function
 Return the FOR expression of an Order
------------------------------------------------------------------------------
 Syntax

     ORDFOR(<cOrderName> | <nOrder>
        [, <cOrderBagName>]) --> cForExp

 Arguments

     <cOrderName> is the name of the target Order, whose cForExp is
     sought.

     <nOrder> is an integer that identifies the position in the Order
     List of the target Order whose cForExp is sought.

     <cOrderBagName> is the name of an Order Bag containing one or more
     Orders.  You may specify <cOrderBagName> as the filename with or without
     the pathname or appropriate extension.  If you do not include the
     extension as part of <cOrderBagName> CA-Clipper uses the default
     extension of the current RDD.

 Returns

     ORDFOR() returns a character expression, cForExp, that represents the
     FOR condition of the specified Order.  If the Order was not created
     using the FOR clause the return value will be an empty string ("").  If
     the database driver does not support the FOR condition, it may either
     return an empty string ("") or raise an "unsupported function" error,
     depending on the driver.

 Description

     ORDFOR() is an Order management function that returns the character
     string, cForExp, that represents the logical FOR condition of the Order,
     <cOrderName> or <nOrder>.

 Examples

     .  This example retrieves the FOR condition from an Order:

        USE Customer NEW
        INDEX ON  Customer->Acct ;
           TO  Customer          ;
           FOR Customer->Acct > "AZZZZZ"

        ORDFOR( "Customer" )      // Returns: Customer->Acct > "AZZZZZ"

 Status:  New

 See also:  INDEX, ORDKEY(), ORDCREATE(), ORDNAME(), ORDNUMBER()