Subject Re: [IBO] KeyLinks AutoDefine
Author Artur Anjos
Jason, I have use it with no luck.

When I use KeyFields AutoDefined, and do a simple select in a table choosing the table Primary Key, I thougth that IBO will detect a Primary Key and use it, instead of cretating the field ID_KEY. Am I rigth?


Table (
A_ID PrimaryKey
A_XX OtherField

If the Query is SELECT A_ID,A_XX FROM TABLE what will IBO do when KeyLinksAutoDefined=True? Generate a Field ID_KEY or use A_ID as primary key?

In this small example I have ID_KEY in the KeyFields array, after Prepare.


----- Original Message -----
From: Jason Wharton
Sent: Tuesday, October 30, 2001 8:51 PM
Subject: Re: [IBO] KeyLinks AutoDefine

Use the KeyFields array.
You actually get an array of TIB_Column objects for the KeyLinks columns
that are in use.
If there are no actual columns then it fabricates an integer column and uses
an arbitrary value.

Jason Wharton
CPS - Mesa AZ

----- Original Message -----
From: "Artur Anjos" <arsoft@...>
To: <>
Sent: Tuesday, October 30, 2001 9:48 AM
Subject: [IBO] KeyLinks AutoDefine

> If I set KeyLinks to 'Autodefine', how can I get the name of the Field
that IBO is using for KeyLinks?
> The property KeyLinks always shows 'DB_KEY', even if IBO is smart enough
to find a better one.
> Artur

Yahoo! Groups Sponsor

IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________ - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

[Non-text portions of this message have been removed]