Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Looking for a record
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00111724
Message ID:
00111864
Vues:
13
>I have a base form class which runs an instance of a toolbar. The toolbar has the standard buttons for navigation. I also want to have a button to find a record. I'd like to be able to use it with either tables or views.
>
>I want similar functionality to the find button found in the VFP WizStyle.VCX txtbtns class. I'd use that one but it is based on filters and locate. As a result it is incredibly SLOW!!!
>
>The tables I'll be searching are around 75,000 records and 15MB in size. At this time I do not need to search Memo fields...but that would be a nice bonus.
>
>If you have any code, classes, downloads, or 3rd party ideas....
>
>Thank you

Hello Richard,

I don't think anything is going wrong with your code/method to find
record. If you have proper indexes on the table retrieval will be a matter
of seconds. Index all the fields used in FOR clause of LOCATE and try.

Good Luck.

Bye
Jayesh
- Jayesh
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform