Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SEEK command
Message
De
25/04/1998 19:18:25
 
 
À
25/04/1998 08:31:11
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Divers
Thread ID:
00094815
Message ID:
00094933
Vues:
40
Using the Upper() in the index is sometimes problematic because it makes Rushmore optimization a little trickier. (You have to always use the upper() in the operation.) Nonetheless, it is probably a good idea to use it with a client name. Anyway, Quinn - here's the solution all put together and guaranteed to work:

Now:
1. Select Client && Assuming client is the name of your client table
2. Index on Upper(Cl_Name) Tag UCl_name && cl_name is the client name field


Later, in your code:
1. Make sure the client table is in use in Some workarea.
2. l_lRetVal = ;
Seek(PadR(Upper(txtTextBox.Value),FSize('cl_name','clients'));
,'clients','UCl_name')

If that doesn't work, shoot me.

Adam
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform