Paradox Community

Items in pnews.paradox-programming

Subject:Re: Fitler TableFrame Records
Date:Sun, 8 Mar 2020 15:32:44 +1100
From:Tom Krieg <REMOVEtomkCAPITALS@sdassociates.com.au>
Newsgroups:pnews.paradox-programming
It's easy. In your case, you need a secondary index on customer number. 
Then, in the changevalue of the Customer_no field, just set the range to 
the new customer number.

When the for opens, in the init event
<TableAlias>.switchindex("customerindex")

in the changevalue event
<TableAlias>.setrange(Customer_no.value, Customer_no.value)

Maybe issue a table refresh afterwards if the form's slow to refresh.


On 7/03/2020 9:45 pm, Kevin Baker wrote:
> Tom-
> 
> Thanks for the help.  I did try the setRange but for some reason, I 
> can't wrap my head around how to get it to work.  I've read setRange is 
> faster and I'll need fast, so I may go back and try and get setRange to 
> work.
> 
> Thanks for the help - Kevin


Copyright © 2004 thedbcommunity.com