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?