NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: kevin plummer on January 05, 2010, 08:32:48 PM

Title: Unique Key
Post by: kevin plummer on January 05, 2010, 08:32:48 PM

Hi All,

Is there a problem if a field has a value of blank and that field is the Unique Field for a key?

I have several tables with blank fields which represent no code. In the browse for these tables if  sort on this field, I cannot select any other record in the browse. If I sort on the next field then it is ok.

Cheers,

Kevin

Title: Re: Unique Key
Post by: Bruce on January 05, 2010, 09:51:40 PM

Hi Kevin,

two issues here -

if you have several records with the blank field, then how is the key unique?

and yes - the identifier field for a row will cause problems if it is blank.

cheers
Bruce

Title: Re: Unique Key
Post by: kevin plummer on January 06, 2010, 04:15:13 AM

several tables with 1 blank field each so unique.

As a workaround, I'm going to just fllter out the blank record which I think works better anyway