>In the command window, the SEEK() function finds a certain record. In the executable, it doesn't. I already checked, with the debugger:
>
>

That the same table is accessed.
>

That the same index is used.
>

That the seek expression is the same.
>

That the table isn't filtered in either case.
>

SET DELETED is ON in both cases.
>

SET COLLATE is MACHINE in both cases.
>
>Are there any other methods to foul up the SEEK() function?
>
>TIA, Hilmar.

Check for SET EXACT

If it's not broken, fix it until it is.


My Blog