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--