Is there a bug with the SEEK function sometimes not using the TagName? I'm using VFP 6 and my tables are not buffered they are opened using just the USE table statement. But I have a line of code that state

IF SEEK(value, 'mytable','order')
   *-- do something
ELSE
   *-- do something else
ENDIF

It hits the else statement even when it should find it. The table is open but with a different order by and it's not the currently selected table. If I select the table first or issue a SET ORDER TO order IN mytable then the seek works. I've also had issues with no order being set and getting a message that an index order needs to be set even when I specify the order in the seek function. This table has no filter set no relationship set nothing. If I'm in the debugger and watch it hit the else and set the next statement back to the seek function it works.