DAO.Recordset[3354] when adding FK to association

[Markos Fragkakis]

Hello,

I have created an ER diagram in Enterprose Architect 6.5 for my database schema (manually, not importing the schema from the DB itself). I am trying to create a FK association between two tables. I am able to draw the association, but when I click on it and select "Foreign Keys", I get a popup saying:

DAO.Recordset[3354]

At most one record can be returned by this subquery

You can see the popup in the attached here:

When I press the OK button, I get the dialog with the columsn of the two tables, only that in one table only two of the 6-7 columns appear, not including the one I want to declare to be a FK. I am able to create normally FKs in several other ocasions. I have dropped and re-created the column in both tables of the relation. I have even dropped and re-created manually the "from" table of the relation, but the problem persists.

Any ideas?

[Paolo F Cantoni]

Hi Markos,

Are you really still using 6.5?  As I recall, the Foreign Keys stuff was rough in 6.5.  Try it again with the latest version.  I think you'll find it works properly now.

HTH,
Paolo

[Markos Fragkakis]

Well,  even if the company I work for accepts the upgrade, it will have to be for all workstations, as other people work on the same model. So, unless an upgrade for all workstations takes place, it will be like hiding the problem under the carpet.

The strange thing is that FKs work correctly in all other occasions.

[Paolo F Cantoni]

Hi Markos,

My point was purely for diagnostic purposes.  If build 850 doesn't produce the problem, then Sparx may be able to more quickly isolate what the issue is.  Also, as I said, I think the FK functionality WAS broken in 6.5.

Also, are you saying it's ONLY this particular Association that's causing the problem?  If so there are some experiments that you can do to help narrow the source of the problem.

Finally, using a working version to fix a problem needn't be "sweeping under the carpet".  Once "fixed" the connector may behave perfectly OK with 6.5.

Firstly, though, you need to find what the problem is...
HTH,
Paolo

[Markos Fragkakis]

I installed the trial version, which indeed allowed me to put the FKs where needed.

I opened again the file with 6.5, and when I right-clicked on the relation (now a FK) and clicked on Foreign Keys, I got the same error.

So, I suppose that as long as I do not need to edit the particular relation, I can live with that.

Thanks Paolo!

[Paolo F Cantoni]

So, I suppose that as long as I do not need to edit the particular relation, I can live with that.!

Hi Markos,

If it is (as it seems) only THAT relation, then I'd do two things...
1a) Create a duplicate (but differently named) tables for both ends - this is so I could check if the problem was the relation.
1b) move the relation to now link the two new tables - then see if there is still a problem (then it's probably the connector itself)
2) Add a new duplicate relation between the two original tables and see if that has a problem (if not - you've just got a workaround).

That should help you decide where the problem is and take appropriate action.

Paolo

[DavidHMeadow]

Go to Project> Documentation. You are looking for the HTML or RTF options.