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.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)