JoinLinks property

Applies to
TIB_Dataset

Declaration
Property JoinLinks : TIB_StringList;

Description
This property can play a very important role in th IB_Query component.

It is used to define join and filter criteria necessary for ensuring that the columns in the KeyLinks property will accurately define each row of the output uniquely.

This is so that the internal cursors that are used to fetch single record buffers will be able to have simpler WHERE clause criteria and not be subject to re-preparing every time the search criteria changes. It also makes it so that the amount of input parameter data necessary to fetch the individual rows is kept to an absolute minimum. Ideally, only key data should be used as input parameter data for selecting individual rows. If the input parameters used to define the entire dataset needed to be included for the fetching of each individual record then performance would be severely degraded. This property plays an important role in avoiding these degradations.