AUSED()
From Lianjapedia
Revision as of 10:50, 4 February 2013 by Yvonne.milne (Talk | contribs)
Contents
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 )