devxlogo

Variable Returning Matches in a Select Query

Variable Returning Matches in a Select Query

Question:
What is the variable that returns the number of matches in a select query?

I thought I’d seen a reference to a variable (something like “_COUNT”) but now I cannot find any reference to it.

Answer:
The _TALLY system variable is what you are looking for. _TALLY holds the number of records that the last query generated.

devx-admin

Share the Post: