ABL enhancement: a fast method for getting the number of results of a query

  • Thread starter Thread starter Marko Myllymäki
  • Start date Start date
Status
Not open for further replies.
M

Marko Myllymäki

Guest
Background: It would often be useful to know the number of records returned by a query before actually fetching the records (how many rows the query would return if it was opened now?). A work-around is to loop through the records in a separate FOR EACH loop (using FIELDS option to minimize the amount of transferred data), but it can be quite slow. NUM-RESULTS attribute of a query object is updated too late, after the records have already been fetched. Enhancement request: Add a new attribute/method for returning the (estimated) number of results satisfying a query without fetching any data. E.g.: iNumResults = hQuery:NUM-RESULTS-ESTIMATION.

Continue reading...
 
Status
Not open for further replies.
Back
Top