Programmatically specify Primary and Foreign Key fields
Hello. I am using the Delphi edition of AQB to write queries against Actian Pervasive database.
When adding a table to the querybuilder, I do not see the primary key indicator against PK field(s) as I do when querying SQL Server databases. I guess this is to with limitations of Pervasive and the way you gather schema metadata?
Is there a way to programmatically specify what fields in the table are PKs? Similar to the way aliases are defined.
Also - Is there an indicator for Foreign Key fields? This would make it easier for end users to do table joins.
If so, same question: Is there a way to programmatically specify what fields in the table are Foreign Keys?