Subject | Re: [IBO] KeyLinks Was: Setting TIBODatabase.DataBaseName property |
---|---|
Author | Jason Wharton |
Post date | 2003-10-23T23:27:58Z |
> Let me ask a question about Keylinks, if I got it right, the KeyLinksshould
> refer to a field which is not necessarily a primary key of a table butDoesn't have to be a primary key but it does have to be unique for the data
> rather a field which uniquely identifies a record in the table.
being queried from. That's an important distinction between data queried
from and data returned into the buffers. The KeyLinks columns are used to
uniquely identify data on the server as well as data in the buffer.
> What about tables that don't have such field (I have tables which need 2-3You can have more than one column in the KeyLinks. Though, it will consume
> primary keys to uniquely identify a record...)?
more memory in the buffers because they are not trimmed and compressed. I
suggest you use a surrogate key if possible.
> Letting the KeyLinksAutoDefine to True should work fine, shouldn't it?Depends.
PS. Please ask questions in an appropriately labelled message. One per topic
unless somehow inter-related.
Jason