[<<Previous Entry]
[^^Up^^]
[Next Entry>>]
[Menu]
[About The Guide]
ORDNAME()
Return the name of an order in the order list
------------------------------------------------------------------------------
Syntax
ORDNAME(<nOrder>[,<cOrderBagName>]) --> cOrderName
Arguments
<nOrder> is an integer that identifies the position in the order
list of the target order whose database name is sought.
<cOrderBagName> is the name of a disk file containing one or more
orders. You may specify <cOrderBagName> as the file name with or
without the path name or appropriate extension. If you do not include
the extension as part of <xcOrderBagName>, CA-Clipper uses the default
extension of the current RDD.
Returns
ORDNAME() returns the name of the specified order in the current order list
or the specified order bag if opened in the current order list.
------------------------------------------------------------------------------
Description
ORDNAME() is an order management function that returns the name of the
specified order in the current order list.
If <cOrderBagName> is an order bag that has been emptied into the
current order list, only those orders in the order list that correspond
to <cOrderBagName> order bag are searched.
The active RDD determines the order capacity of an order bag. The
default DBFNTX and the DBFNDX drivers only support single-order bags,
while other RDDs may support multiple-order bags (e.g., the DBFCDX and
DBPX drivers).
Note: ORDNAME(0) works as ORDNAME(INDEXORD()).
Examples
. This example retrieves the name of an order using its position
in the order list:
USE Customer NEW
SET INDEX TO CuAcct, CuName, CuZip
ORDNAME(2) // Returns: CuName
. This example retrieves the name of an order given its position
within a specific order bag in the order list:
USE Customer NEW
SET INDEX TO Temp, Customer
// Assume Customer contains CuAcct, CuName, CuZip
ORDNAME(2, "Customer") // Returns: CuName
See Also:
ORDFOR()
ORDKEY()
ORDNUMBER()
This page created by ng2html v1.05, the Norton guide to HTML conversion utility.
Written by Dave Pearson