Home page  
Help >
2.104 ddlTally() - count records in collection
Version 7.11
2.104 ddlTally() - count records in collection 2.104 ddlTally() - count records in collection

Prototype:
   void ddlTally(
      CONTROL *ctl,
      char *OptnStr,
      char *ArgList);

Permitted values in OptnStr:
/Z - suppress tables with zero records

Form of ArgList:
      <cx> [<table-name>]

Description:
Display the record count for a collection.

If <table-name> is specified, the record count for the specified <table-name> in the collection is displayed. If a sorted collection exists for <table-name>, its record count is also displayed.

If <table-name> is not specified, the record counts for all tables in the collection, as well as the global collection, are displayed. If sorted collections exist for specific tables, or for the global collection, their record counts are also displayed.

The global tally also displays the current hierarchy as defined by the most recent ddlOrder(), ddlRelate() or ddlRelateEx(). The default order for a collection is the order of the tables in the DBD.

Values returned in Control Structure:
Control.Ans1 number of records in the raw collection (32 bits)
Control.Ans1L number of records in the raw collection (64 bits)

Copyright © 2019 , WhamTech, Inc.  All rights reserved. This document is provided for information purposes only and the contents hereof are subject to change without notice. Names may be trademarks of their respective owners.