When I execute TIBQuery.RecordCount why doesn't it give me a count of all my records in my Query?

TIBQuery.RecordCount does the same thing as TIBSQL.RecordCount. Here is what Help says for TIBSQL.RecordCount:

Use the RecordCount property to see how many records are returned by a query. If the result set is to return 100 rows, RecordCount will only be 100 after all the records have been visited. That is, after looking at the first record, RecordCount is 1, and so forth.

The reason RecordCount operates in this fashion is calculating all the records in a dataset is potentially time consuming operation as it would require scanning through the entire dataset. The most efficient way to calculate the number of records in a dataset is to execute a SELECT COUNT(*) statement.

6 Responses so far.

  1. tarakan says:

    looks nice. but have you ever heard about another way of recover a saved over illustrator file provided by appropriate data recovery services?

Post a Comment

Thank you for your comment.

Any request and idea are welcome.