|
This function will retrieve the COUNT of
records retrieved by the SQL statement.
TCOUNT(SQL , Server)
PARAMETERS
SQL
The SQL statement which determines which records to
count.
Server
The Server used to query against .. use --- for the local
device
Example:
Count
how many customers live in the city of Toronto,
and store the number in a memory variable named
TORONTOCUSTOMERS
SETMEM(TORONTOCUSTOMERS//TCOUNT(“SELECT
* FROM MyCustomers
WHERE
City
= ‘Toronto’”,”---“))
MESSAGE(“There
are “ <!TORONTOCUSTOMERS!> “ in
Toronto”//”Total”) |