NetTalk Central

Author Topic: Problem with Lookup  (Read 4469 times)

bergsj

  • Jr. Member
  • **
  • Posts: 81
    • MSN Messenger - swjvandenberg@hotmail.com
    • View Profile
    • Email
Problem with Lookup
« on: January 26, 2011, 02:17:18 AM »
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?


Greetz,
Sjoerd

Bruce

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 11244
    • View Profile
Re: Problem with Lookup
« Reply #1 on: January 26, 2011, 10:25:22 PM »
What field is in the declaration of RVAUnique Key?

bergsj

  • Jr. Member
  • **
  • Posts: 81
    • MSN Messenger - swjvandenberg@hotmail.com
    • View Profile
    • Email
Re: Problem with Lookup
« Reply #2 on: January 26, 2011, 11:47:08 PM »
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 ;)
Greetz,
Sjoerd

Rene Simons

  • Hero Member
  • *****
  • Posts: 650
    • View Profile
Re: Problem with Lookup
« Reply #3 on: January 28, 2011, 04:22:11 AM »
Hallo Sjoerd,

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

Groetjes,
Rene
Rene Simons
NT14.14

bergsj

  • Jr. Member
  • **
  • Posts: 81
    • MSN Messenger - swjvandenberg@hotmail.com
    • View Profile
    • Email
Re: Problem with Lookup
« Reply #4 on: January 28, 2011, 05:10:47 AM »
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
Greetz,
Sjoerd

Rene Simons

  • Hero Member
  • *****
  • Posts: 650
    • View Profile
Re: Problem with Lookup
« Reply #5 on: January 29, 2011, 01:03:27 AM »
Mmmmmmmmmmm.
Rene Simons
NT14.14