contents.gifindex.gifprev1.gifnext1.gif

Cust_Rcrd_List_Count

Purpose

Returns a count of how many records in CUST_RCRD match a list of keys.

Arguments

Cust_Rcrd_List_Count(

<Record_Class>

, <key list>
// A list of zero or more possible RCRD_KEY values.
, <delims>
// For <key list>, one or two.
)

Example

Asssume CUST_RCRD contains the following rows:

RCRD_CLASS
RCRD_KEY
%T001
%T002
CustType
123
abc
ABC
CustType
234
def
DEF
CustType
345
ghi
GHI
CustType
456
jkl
JKL
CustType
567
mno
MNO
CustType
678
pqr
PQR

Cust_Rcrd_List_Count( "CustType", "234"
, "," )
Returns: 1
Cust_Rcrd_List_Count( "CustType", "234"
, "," )
Returns: 0 List not delimited properly.
Cust_Rcrd_List_Count( "CustType"
, "123,678,999,234," , ",")
Returns: 3 "999" not there.
Cust_Rcrd_List_Count( "CustType"
, "[123][678][999][234]" , "[]" )
Returns: 3
Cust_Rcrd_List_Count( "CustType", ""
, "[]" )
Returns: 0
Cust_Rcrd_List_Count( "CustType"
, "[123][123][123][123]"
, "[]" )
Returns: 4
Cust_Rcrd_List_Count( "CustType"
, ".123.678.999.234."
, ".." )
Returns: 3