Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Server slower than VFP?
Message
De
09/08/1999 12:11:02
Walter Meester
HoogkarspelPays-Bas
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00250319
Message ID:
00251546
Vues:
16
Mark,

>What I am tring to accomplish is a search/lookup function. The user inputs a last name, say 'SMITH', and if there is more than one match (and with this last name there are, of course), he must select from a list of further details such as SSN, account#, etc... I realize there are other methods in which to accomplish this task that don't require a large browse window, but this is the method our users are already familiar with, and I would rather not make the task more difficult after they 'upgrade'.

Well, Anything that is used for lookup should be implemented within a VFP table for performance reasons. If the lookuptable changes quite often, you can use SQL server's replication feature to update the VFP lookuptable trough ODBC. Within VFP you may want a incremental search withing a grid.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform