Home page  
Help >
ddlFindCalc() - isolate records in a collection using Calc-Object
Version 7.11

ddlFindCalc() - isolate records in a collection using Calc-Object ddlFindCalc() - isolate records in a collection using Calc-Object

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

Permitted values in OptnStr:
   /Cn - return first n values only

Form of ArgList:
      Case 1: <cx> [<dgname>] <expression>
      Case 2: <cx> [<dgname>] <cx> AND <expression>

Description:
First, ddlFindCalc() creates the Calc-Object:
       IF <expression>
          SELECT <cx>
       ENDIF
Then, in case 1:
      • Clears the collection <cx> [<table-name>];
      • Performs the Calc-Object against all records in <table-name>; or, if <table-name> is not specified,
         against all records in all tables
In case 2:
      • Copies the collection <cx> [<table-name>]; to a tempory collection
      • Clears the collection <cx> [<table-name>];
      • Performs the Calc-Object against all records in the temporary collection;

Value returned in Control.Ans1:
Control.Ans1 Total number of records selected
Control.Ans2 If the /Cn option was used, this is the number of records selected before the /Cnnn limit was applied; else, it is a duplicate of Control.Ans1

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.