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.
FIBPlus has taken the headache out of this project. When I got the current contract, FIBPlus was included on the work computer from the client. I quickly found it easier to use and more powerful than any other Firebird component suite I had tested. When I ran into a problem setting up a persistent calculated field, the tech support people saved the day. I would also add that I tested Zeos, IBX, DBGo, UIB, and other FBconnectors. FIBPlus outperformed all of them, and FIBPlus was run on an older machine than the others were. That was most impressive.>>