>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?
Is your table buffered and are you seeking before you commit the changes? Index wouldn't be updated until you commit the changes. Locate looks at the values of a field.
Dawa Tsering
"Do not let any unwholesome talk come out of your mouths,
but only what is helpful for building others up according to their needs,
that it may benefit those who listen."
- Ephesians 4:29-30 NIV
Dare to Question -- Care to Answer
Time is like water in a sponge, as long as you are willing you can always squeeze some.
--Lu Xun, Father of Modern Chinese Literature