Office Connector Web HelpOnline Help

TSCount Function

Contents Index


 The TSCount function counts the number of records in a specific table.  Conditions may be applied to limit which records are included in the total.

Syntax

TSCount( table name , [ filter ])

The TSCount function syntax has these parts:
ArgumentDescription
table nameRequired. This argument identifies an SQL statement or a specific internal table name in the Timberline Office database.  If this argument does not supply a valid source of data, then the result of the function will be #TABLE? ("table name" not found).
filterOptional.  A filter is a string of text that includes comparisons between fields in the table and specific values.  Only the records that satisfy the filter conditions will be used to return values.

Example

Click here for examples.


See Also



Content updated 12/4/2012

Copyright 2012 Event 1 Software, Inc.  This documentation may not be copied in full or in part without written permission from Event 1 Software, Inc.