Board index » delphi » recordcount

Eoyore

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

recordcount

Hello-

I have a tquery with a request live option set.
When I set active to true and an empty dataset is returned
the recordcount doesnt indicate zero.
I tried browsing the manual and online help awhile.
I figured I'd post because the lightning might be coming and it looks
like I might run out of time to figure this out.

thanks
jim

 
Eoyor

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:recordcount


right after I posted I came up with this generic solution.
thanks anyways
jim

var
i: integer;

begin
i:=0;
query2.first;
while not query2.eof do
begin
inc(i);
query2.next;
end;
showmessage(inttostr(i));

Quote
Eoyore wrote:
> Hello-

> I have a tquery with a request live option set.
> When I set active to true and an empty dataset is returned
> the recordcount doesnt indicate zero.
> I tried browsing the manual and online help awhile.
> I figured I'd post because the lightning might be coming and it looks
> like I might run out of time to figure this out.

> thanks
> jim

Robert Kapla

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:recordcount


You can also check IsEmpty
Quote
Eoyore <m...@slic.com> wrote in message news:394B4004.8552E515@slic.com...
> right after I posted I came up with this generic solution.
> thanks anyways
> jim

> var
> i: integer;

> begin
> i:=0;
> query2.first;
> while not query2.eof do
> begin
> inc(i);
> query2.next;
> end;
> showmessage(inttostr(i));

> Eoyore wrote:

> > Hello-

> > I have a tquery with a request live option set.
> > When I set active to true and an empty dataset is returned
> > the recordcount doesnt indicate zero.
> > I tried browsing the manual and online help awhile.
> > I figured I'd post because the lightning might be coming and it looks
> > like I might run out of time to figure this out.

> > thanks
> > jim

Other Threads

1. Question about the RecordCount property

2. Dataset recordcount

3. Why does RecordCount gets Lost

4. RecordCount Problem

5. DBGrid focus on RecordCount = 0

6. RecNo e RecordCount in ACCESS 97

7. Problem in RecordCount with Delphi4 and Paradox

8. TTable.recordCount problem!

9. cgi app query1.Recordcount always returns 0

10. RECORDCOUNT Problem !!!