$sqlresult.... vars

More information about the <SQL> query being executed, set at every iteration and at the end of the loop. $sqlresult.returnedmin and $sqlresult.returnedmax are the minimum and maximum number of total (i.e. ignoring SKIP and MAX) result rows that will be returned. In cases where the exact number of result rows is not yet known (e.g. post-processing is required), the two will differ. If the upper or lower limit is not known (e.g. a completely unindexed query), one or both variables will be negative. If both variables are equal, the total row count is exact.

$sqlresult.matchedmin and $sqlresult.matchedmax are similar, but are the min/max total rows matched - i.e. by the WHERE clause, before any reduction by likeprows, GROUP BY etc.

$sqlresult.indexcount is the same as $indexcount, but is set to -1 (not 0) when unknown, to distinguish from 0 (known but zero results).

The $sqlresult.... variables were added in version 6. They are more accurate than the $rows.... variables, as their information is obtained directly from the Texis SQL engine. See here for more on these variables.

Copyright © Thunderstone Software     Last updated: Apr 15 2024
Copyright © 2024 Thunderstone Software LLC. All rights reserved.