Subject | RE: [IBO] Re: record count |
---|---|
Author | Beyers Cronje |
Post date | 2004-02-09T13:51:48Z |
I might be way off, but couldn't you use the "EndRowNumber" or
"LastRowNumber" , cant remember the exact name, property of TIB_Query?
-----Original Message-----
From: Svein Erling [mailto:svein.erling.tysvaer@...]
Sent: Monday, February 09, 2004 15:36
To: IBObjects@yahoogroups.com
Subject: [IBO] Re: record count
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
"LastRowNumber" , cant remember the exact name, property of TIB_Query?
-----Original Message-----
From: Svein Erling [mailto:svein.erling.tysvaer@...]
Sent: Monday, February 09, 2004 15:36
To: IBObjects@yahoogroups.com
Subject: [IBO] Re: record count
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?
___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !
Yahoo! Groups Links
This is an email from CS Holdings. It is confidential to the ordinary user of the email address
to which it is addressed and may contain copyright and/or legally privileged information. No one
else may read, print, store, copy, forward or act in reliance upon all or any part of it or its
attachments. If you received this email in error please notify its sender.