Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Faster way to search for a word
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
01322854
Message ID:
01322873
Vues:
14
It looks like you are looking for 'HARDDISK' at the start of the field ( AT()=1 )
The best way would be to have an index on the UPPER(stockname)

Then

Browse for upper(stockname)='HARDDISK'

OR

Browse Key 'HARDDISK' (After Index is set)

OR

SELECT * FROM TableName WHERE UPPER(stockname)='HARDDISK'

Without testing I would guess the second is fastest

Bob



>what's the fastest way to search for a word?
>
>I use:
>
>SET FILTER TO AT(UPPER('HARDDISK'),UPPER(stockname))=1
>BROWSE
>
>but I think it's too slow
>
>thanks for the help
>
>Jerry
'If the people lead, the leaders will follow'
'War does not determine who is RIGHT, just who is LEFT'
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform