Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Seek function on index key
Message
De
16/03/2001 07:54:55
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
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:
00485795
Vues:
10
>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.

Carmen,
Sure you can as long as 'set exact off' (default). It would mean 'begins with'
if seek('1K','mytablename','mytagname')
...
Seeks first occurence of type 1 and Code K... on any date.

Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform