>
>CREATE DATABASE temp
>CREATE TABLE anytable (pkey I PRIMARY KEY, cChar C(6))
>SELECT anytable
>INDEX ON cChar TAG cChar
>SET ORDER TO pkey
>SET MULTILOCKS ON
>CURSORSETPROP('Buffering',5)
>
>
>Unfortunately, got the exact same results :-(
The issue seems to be that the new record hasn't been committed. If you add a TableUpdate() before the INDEXSEEK(), you get the expected results.
I am a little surprised by this myself, since the whole point of INDEXSEEK() is to be able to search in buffered tables without committing records.
Tamar