General information
Category:
Forms & Form designer
>Hi Arnold,
>
>If you have index on the table you can use command SET KEY TO, which limits
>displayed record only to those having index expression of certain value or
>within a range of two values. This gives much higher performace then SET
>FILTER TO.
>
>Jarda Lang
>
>
>
>
>Hi,every VFP developer
>
>
>I have a large database file consists of 50,000+ records in VFP 5.0.My form
>have a grid control display records from it.But I want to limit display
>parts of it.By consulting Microsoft Knowledge base,they suggests uses "SET
>FILTER TO" command.But the performance in grid is very slow even the filter
>field was indexed on it.
>Anybody have a idea to limit display records in grid other than uses SET
>FILTER TO ?
>
>Thanks.
>Arnold
>
>Attachment Converted: WINMAIL.DAT
Hi,Jarda
Thanks for your kind advise by using SET KEY TO.I Uses this command in Command Window and the browse,it work nice.But the result is differenet when I used with Grid Control in a form.Do you thing Grid Control do not take advantage of Rushmore technology ? In my opinion,the Grid Control should have a "FOR" property to let user specificy the For Condition like Browse do.
Thanks for you kind attention
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only