AUSED()

From Lianjapedia
Revision as of 10:50, 4 February 2013 by Yvonne.milne (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Purpose

Function to load the alias name and cursor/workarea number of all open tables into an array

Syntax

AUSED(<array-name>)

See Also

ALIAS(), DATABASE(), DBC(), DBF(), SELECT, SELECT(), USE, USED()

Description

The AUSED() function is used to load the alias name and cursor/workarea number of all open tables into a two-dimensional array and return the number of tables loaded (and hence the number of array rows).

The <array-name> array will be created if it does not already exist. The first element in each array row will contain the table alias, the second the cursor/workarea number.


Example

? aused(alianjademo)
         7
? alianjademo
Array (refcnt=1)
(
    [1,1] = CUSTOMERS
    [1,2] = 1
    [2,1] = ORDERS
    [2,2] = 2
    [3,1] = ORDER_DETAILS
    [3,2] = 3
    [4,1] = EMPLOYEES
    [4,2] = 4
    [5,1] = ATTACHMENTS
    [5,2] = 5
    [6,1] = EMPLOYEES_CALENDAR
    [6,2] = 6
    [7,1] = EXAMPLE
    [7,2] = 7
)