Why are some records lost when I use the Locate method in the cmkLimitedBufferSize mode?
Fast, flexible and high-performance component library for Delphi, C++ Builder and Kylix intended for work with InterBase and Firebird using Direct InterBase API.
|
Question: Why are some records lost when I use the Locate method in the cmkLimitedBufferSize mode?
Answer: This effect appears only if you incorrectly set the “order by” clause in the Select query. For the cmkLimitedBufferSize mode in “order by” you should use fields with the unique values for each record. So fields values in the “order by” clause should not repeat, otherwise you will get bugs not only when you use Locate, but also when you simply scroll on the records.
You're doing great job with this product. 