>Nadya,
>
>The problem turned out to be actual changes in the data - and buffering problems. See my reply to myself, if you are interested in the details.
>
>Hilmar.

Thanks, I saw it after I sent my message...

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