[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: How to add a FOREIGN KEY to an existing table?

  • Thread starter Thread starter Dileep Dasa
  • Start date Start date
Status
Not open for further replies.
D

Dileep Dasa

Guest
YerAmil , You are right that we can have foreign keys at SQL level and the article describes the same. I tired the steps mentioned by you in the first post and I am facing the same error that you see: SQL Error [HY000]: [DataDirect][OpenEdge JDBC Driver][OpenEdge] No matching key defined for the referenced table (7545) I also tried after some trivial changes to .df files like changing INITIAL from "" to "?" but nothing worked. Then I tried creating the same tables from SQL with "not null primary key" constraint for "cust_num" column while creating tables. This way, adding a foreign key constraint worked without any errors. So, there is some difference between creating tables from ABL/Dictionary and SQL which is causing the errror.

Continue reading...
 
Status
Not open for further replies.
Back
Top