>first I select the table
>Then I do a seek
>it does'nt work
>
>I traced what's happening in the debugger. After the seek I looked to see where was the pointer in the table. Pointer was at the right place. So in debugger it works ok as long as I check for the the content of the table. Out of the debugger the pointer is not positioned at the right place after the seek.
>
>I replaced the seek by a locate and everything works fine.
>
>Why would I have this behavior with the seek?
SET EXCACT?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.