>Hi Denis ---
>
>We have seen this one before. There seems to be a problem with SEEK and datetimes.....the solution would be to use TTOC() in the index expression and the SEEK.

John,

The problem is that DateTime is stored with an resolution to milliseconds, but we can only access to seconds, therefore there is little possibility that the value we seek will exactly occur in the data. SET EXACT OFF and SET NEAR ON may help with this.