Subject KeyLinks & Primary Keys
Author Chris Landowski
I have several tables in a database that have no primary keys. Instead these
tables have a unique index. If I use a TIBOQuery component with the KeyLinks
property set to the fields of the unique index, IBO will spike the server
for about a half a second every time I post an edit. If I clear the KeyLinks
and set KeyLinksAutoDefine to True, the KeyLinks property gets defined as
RDB$DB_KEY and everything appears to work much better This does not happen
with all tables that do not have a primary key and I am wondering if someone
could tell me why this is happening ? Is there anything special that needs
to be taken into consideration when using the KeyLinks property against
tables that do not have a primary key ?

Thanks in advance,

Chris Landowski
Dynamic Software Solutions