Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Puzzling Indexing
Message
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01314360
Message ID:
01314365
Views:
9
What is index key expression for the second index? Is SET EXACT OFF at the time when SEEK is executed?

>I've got a couple index tags, one of which doesn't seem to work until I get both parts of it together for seeking. Unfortunately, I am doing a combo seek, based on two fields of data. I do it intereactively within a form as the user types each character.
>
>The first Index Tag is called Machine and is based on the Machine field only. When I seek on it, it works fine with INDEX TAG MACHINE.
>
>The 2nd Index Tag is MACH_DATE, which is a seek on data such as:
>
>"0301" + "2008/04/30" <--(character date)
>
>When I use the MACHINE Index to search with, it works fine, at least when I search only for the Machine #. However, when I use the MACH_DATE tag to search with, it goes straight to EOF() while in an interactive search when I start searching on "0301" one key stroke at a time. It doesn't work until I have the whole ENCHILADA all put together such as a seek on "030120080430", the first four digits being the Machine #.
>
>What gives? Que pasa?
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform