General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi,
We seem to be having a problem with seek not finding records.
We perform the seek on a table with a that has an index on a char(13) field, and although the record exists, the seek command and the locate command are not finding them. I've even tried using Locate with the NOPTIMIZE clause, but this is also doesn't find the record. What is funny, is if I scatter the record, delete it ( and blank all values), then append a blank and gather into this, the seek command works.
Is there a known bug? and what is the work around - apart from scatter and gather.
Thanks
Macer
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only