Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Seek function on index key
Message
From
16/03/2001 07:54:55
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
16/03/2001 07:24:10
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00485780
Message ID:
00485795
Views:
11
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform