DBCOUNT(Str1, Str2, Str3)

Numeric Expression

Performs a database lookup and returns the number of records that match specified criteria.

• Str1 = Fully qualified name of database file
• Str2 = Name of Table
• Str3 = Selection criteria (specifying names of matching identifiers)

Example:

DBCOUNT ( “c:\lookup.mdb”, ”clients”, CONCAT(“ID=”,SUBJECT) )

The example above will look in the “clients” table of the lookup database for records where the value of the ID field matches the variable SUBJECT. The number of matching records will be returned.

Note: Not supported by the Web Module.