Fritz, You can count anything. You can select the count into a variable
for use in a command file
How many rows in a table:
SELECT COUNT(*) INTO vCount FROM <table>
How many rows in the table have NULL values in a specified column
SELECT COUNT(*) INTO vCount FROM <table> WHERE <column> IS NULL
You can find out how many distinct values you have
SELECT COUNT(DISTINCT CustName) FROM Customers
How many individual customers in your invoice table have customer names
starting with "C" and bought something in the last 90 days?
SELECT COUNT(DISTINCT CustName) +
FROM Customers t1, Invoices t2 +
WHERE t1.CustID = t2.CustID +
AND t2.InvDate BETWEEN (.#DATE and (.#DATE-90) +
AND t1.CustName LIKE 'C%'
What was the last Customer who was invoiced?
SELECT CustID FROM Invoices +
WHERE COUNT = INSERT
Only your imagination can limit the uses. You can get some starting info
by typing
HELP COUNT at the R> prompt to open the help files at the COUNT page if
you updated your help files as CHM.
Albert
On 5/27/2014 11:34 AM, Dr. Fritz Luettgens wrote:
Hi,
can anybody give me a short tip where to find Info in Docs
about function template (COUNT(arg)) ?
- might be I should stop working now :)
Thank´s
fritz
