Thanks Jason / Dmitry
1) After FetchAll record not visible too? No
2) Try set Filter to locate this record... Havnt tried that yet
3) In query OnFilterRecord event are used? No
4) Check isolation level of transaction. tiCommitted

> Use the SQL Trace monitor to see exactly what query is being sent to the
> server.

Done that I see nothing strange in the sql being sent to the server

>
> Are you ordering by a column that perhaps this record has a null
> value for?

No this record has values in all relevant fields.
But even if a field was null surely the record should still be fetched?

Regards Cao