Skip to main content
Previous sectionNext section

SELECTINFO

Returns information about a select list.

Synopsis

SELECTINFO(listnum,key)

Arguments

listnum An expression that resolves to an integer between 1 and 10 (inclusive) that identifies a select list. This value is defined in the SELECT statement. listnum 0 is not valid for Caché MVBasic.
key An expression that resolves to an integer code indicating what select list information to return. The available values are 1 (active), and 3 (count).

Description

The SELECTINFO function returns different values depending on the value of key:

  • If key is 1, SELECTINFO returns a boolean value, indicating whether the specified select list is active. 1=select list is active; 0=select list is inactive. A SELECT command activates a select list. When a READNEXT attempts to read past the last item of the select list, the list is inactivated.

  • If key is 3, SELECTINFO returns an integer value, specifying the total number of items in the select list. It returns 0 if the select list is not active, or if an active select list does not contain any items.

Examples

The following example uses the SELECTINFO function to return information about select list 4:

slist=4
PRINT SELECTINFO(slist,1)
PRINT SELECTINFO(slist,3)
Copy code to clipboard

See Also