Book a Demo

Author Topic: Foreign Key Connectors through Automation  (Read 3322 times)

Kevin Winchester

  • EA Novice
  • *
  • Posts: 8
  • Karma: +0/-0
    • View Profile
Foreign Key Connectors through Automation
« on: February 26, 2008, 03:57:04 am »
I have been creating foreign key connectors through the automation interface, by attempting to duplicate a connector that I imported from an ODBC data source.

This process seemed to work fine, until I ran the "Connectors" Project Data Integrity check, which informed me that my connectors were "Missing Foreign Key Information".  I started investigating, and found that FK connectors are given special text in the StyleEx property of the Connector object.  Something of the form:

FKINFO=SRC=FK_Name:DST=PK_Name:;

However, this is not documented anywhere that I could find (the EA Help file indicated that StyleEx was not used for Connector objects).  Once I adjusted my code to emit the proper string to that property, the Integrity check stopped failing.

Is that the proper way to create FK links through the automation interface?  Is there any documentation somewhere that would explain all of the necessary steps for doing this (in case I missed anything else)?  Is the syntax of the above string guaranteed to be stable between EA versions?
Kevin Winchester