Subject Re: rowset.count()
From Akshat Kapoor <akshat.kapoor@kapoorsons.in>
Date Tue, 10 Sep 2019 11:10:12 +0530
Newsgroups dbase.getting-started

On 10/09/2019 00:54, Andy wrote:
> Vic,
>
> Second attempt.. hoping I don't press the send button too early again by accident.
> My first reply attempted to show the approach I took to putting the old XML commands into OOP code.
> This was an idiotic thing to do ... as I'd have to explain how the custom table object and all it's methods worked.
>
> So the below just shows the essential XML commands which work at lightning speed...
>
> Let's say your table is called "ManyRecords.dbf" and your Filter in your query object is "Amount > 500"
>
> Try inserting the following code where you want to get the count...
>
> use ManyRecords in select()
> set filter to Amount > 500
> private nCount; count to nCount
> set filter to
> use "" in ManyRecords
> msgbox(""+nCount+" records")
>
> This is just a (speedy) alternative.
> Andy

XDML are the best when speed is required. But my aim was to make the
rowset generated usable.

Regards
Akshat