Problem with Lookup

[bergsj]

Hi

I have a browse with EIP lookups. When answering all the lookups they all go OK, but every 4/5 lookups I get this error message:



When clicking OK (on the serverside) it looks like everything is continuing as it's supposed to.

As you can see on the last row (where the message appeared) the unique code is showing. When pressing OK the correct description is visible again.

What can this be?

[Bruce]

What field is in the declaration of RVAUnique Key?

[bergsj]

Bruce,

The table on the browse is the 'link' table of three related tables.
So I have four tables:

-RegistratieVraagAntwoord (RegistratieId,VraagId,AntwoordId)
-Registratie
-Vraag
-Antwoord

As answer to your question: the RVAUniqueKey contains VraagId and AntwoordId, but I have forgotten to put RegistratieId in there as well, since combination VraagId and AntwoordId could possibly already have occurred.

Thanks for shining this light

[Rene Simons]

Hallo Sjoerd,

I have checked THE BOOK, and imho it states that the Unique key must be a single field unique key.

Groetjes,
Rene

[bergsj]

Hoi Rene,

Maybe you are right, but I think this is regarding the PrimaryKey. That is indeed also configured in my browse as the primary key with only one field. But I have an index on the backend (sybase sql) that has a key with three fields. And it was configured for two. So I somethings created non-unique records.

Groeten!
Sjoerd

[Rene Simons]

Mmmmmmmmmmm.