NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: bergsj on January 26, 2011, 02:17:18 AM

Title: Problem with Lookup
Post by: bergsj 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:

(http://www.inforit-ict.nl/docs/NettalkIssue.PNG)

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?

Title: Re: Problem with Lookup
Post by: Bruce on January 26, 2011, 10:25:22 PM

What field is in the declaration of RVAUnique Key?

Title: Re: Problem with Lookup
Post by: bergsj 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 ;)

Title: Re: Problem with Lookup
Post by: Rene Simons 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

Title: Re: Problem with Lookup
Post by: bergsj 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

Title: Re: Problem with Lookup
Post by: Rene Simons on January 29, 2011, 01:03:27 AM

Mmmmmmmmmmm.