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

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

dbeavon

Guest
@YerAmil, Just a warning, the base OE database engine doesn't have FK constraints. It is a relational database without relations. If I had to guess, it probably will never get them. I'm not familiar with adding FK constraints that are enforced in the SQL engine, but there is a KB. You are defining your datadefinitions using the old DF format, but you probably need to do it using an ODBC/JDBC connection to the SQL engine. You can do that with PDSOE or the sqlexp tool, for example. Here is the KB about defining FK's that only impact SQL clients. knowledgebase.progress.com/.../000034195 I'd suggest you vote for this too : community.progress.com/.../make_the_progress_openedge_database_a_relational_database

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