List Address Book’s name and number

The simplest of queries is just the table name or business view. The below sample extends that by adding the aliases we want in brackets.

/* Table */
f0101
/* Fields (Alias) */
(an8,alph)

The expected return is a list of address numbers and names. The size of the list depends on the setting in AIS (default is 100).

List Address Book’s number and Cat Code 21

Example of checking category code 21 for selected numbers.

/* Address Book */
#ab =
/* AB# and Name from Master */
f0101 (an8,ac21)
/* Between AB# 4000 and 4100 */
all(an8 bw 4000,4100)