Re: TZF - SetFilterTo

Pierre,

I also have found SetFilterTo to be slow. If what I want to filter on is
indexed I do my own filtering.

First, I set the order to the proper index. Second, find the first record.
Third, set up a loop and then loop through the records until I find a record
not equal to my filter.

This works a lot faster then SetFilterTo. I have some databases files with
over 250,000 records and I can process the records I need very quickly using
my approach.

Phil Kidder

----- Original Message ----- 
From: "Pierre Wittwer" <[email protected]>
To: <[email protected]>
Sent: Tuesday, January 13, 2004 1:17 AM
Subject: TZF - SetFilterTo


> Hi Topaz-Users
>
> I use a Dbase with about 10'000 records. I have to put a filter similar to
>
>
>
> DBase.SetFilterTo('NUMBER == "'+ actualBill +'"');
> when actualBill ist the string for choosen bill number
> and NUMBER for the searched bill number
>
> It functions, but is very slow. It takes about 10 seconds, to filter the
> Records.
>
> Is there another possibility.
>
> Thank you for your help
>
>
> Pierre Wittwer
> 6370 Stans
> Switzerland
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>

--^----------------------------------------------------------------
This email was sent to: [email protected]

EASY UNSUBSCRIBE click here: http://topica.com/u/?clvXPN.a5kvff.Z2NsZHQt
Or send an email to: [email protected]

TOPICA - Start your own email discussion group. FREE!
http://www.topica.com/partner/tag02/create/index2.html
--^----------------------------------------------------------------