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?