I have successfully connected to tables in an external MySQL database from AwareIM.
The last step is to define shortcuts, which I believe is allowed, but I get the following error:
"Only shortcut attributes can be added to business objects persisted in external tables. However, you do not have any reference attributes defined, so shortcut attributes cannot be created."
The external tables have foreign key constraints (eg: CONSTRAINT FOREIGN KEY (InstitutionID) REFERENCES institution (ID)), but the error persists.
So, can anyone explain to an SQL novice what is meant by "reference attributes"? I would have thought that foreign key constraints would do it.
Connecting to tables in external databases
-
- Posts: 7525
- Joined: Sun Apr 24, 2005 12:36 am
- Contact:
Re: Connecting to tables in external databases
When you were discovering attributes you should have been asked a question whether to use foreign key constrains to create references. Make sure that you answer yes.
Aware IM Support Team
Re: Connecting to tables in external databases
Thanks Support,
Works very well.
Works very well.