Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Seek function on index key
Message
De
16/03/2001 08:16:49
 
 
À
16/03/2001 07:24:10
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00485780
Message ID:
00485812
Vues:
8
>My table structure is code c(8),cdate d(10),type c(1)...)
>
>my index key is type+code+dtos(cdate)
>
>Is it possible to use this index only seek for first two charactor are match
>for example: type = 1,code = K0008,Cdate = 01/02/2001, sometime i will seek index for whole string but occasionaly I use it to seek only the first two character. Is that possible to use this index to seek instead of create another index to seek....
>
>Sorry for my english. coding will be appreciated and thanks.

In your example..

If you wanted to seek for all the records with a type of 1 and a code starting with K
=Seek("1K")
As long as Set Exact is off this will work fine

HTH
Will Jones
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform