Subject Re: record count
Author Svein Erling
Hi James!

Do you need to refresh the count on every post and delete? Why not let
the user click somewhere if he wants to update the record count? I do
not know what your application is doing, but another thing that you
could do, is to do a SELECT FIRST 101 <id> FROM <table> and then walk
through the records counting them. If there's more than 100 then you
could simply respond "More than 100 records". It isn't very useful
when there is only a few records involved, but if you may have
millions of records in your dataset, it can occationally be sensible
doing something like this.

HTH,
Set

--- In IBObjects@yahoogroups.com, James <james_027@t...> wrote:
> Hi everyone.
>
> I have a application where the no of record is needed. I have a
> label component reassigning its caption property onafter post and
> onafterdelete event to the dataset. I feel this method is awkward.
> Is there a better way?