Akshat Kapoor <email@example.com>
||Tue, 10 Sep 2019 11:10:12 +0530
On 10/09/2019 00:54, Andy wrote:
> 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.
XDML are the best when speed is required. But my aim was to make the
rowset generated usable.