Subject:Duplicate rows, locate and findkey fail, nullable index

Company

SQL LINKS DEVELOPER SUPPORT

SEARCH Borland Online/Developer Support

Tech Notes Index

Subject:Duplicate rows, locate and findkey fail, nullable index 6/11/97 7:44am The behavior outlined below can also cause locate/findkey to not work correctly. [Addressed in BDE 4.01] Brief Description: In some cases several duplicate rows appear in the view of data. The reason appears to be that a SQL statement is being generated to retrieve rows after the currently selected row in the data base that is erroneously including rows that are before the current row. ---------------------------------------------------------------------------- Problem because the key field is defined as NULLable. If key fields have valid data no duplicate records are cached. PUB ALL LINK ERROR QW, BC 6.11.97