ifnull

[Danny Lewkin]

Hi Ruslan,

it's inserted as a method, and yes it's set to be unique.
We use this technique all the time, if we want something unique for  
example for a company. Like a loginname and password, that should be  
unique...
We never had problems with that before...

Greetz,

Danny


On 07 Jul 2008, at 15:20, Ruslan Zasukhin wrote:

> On 7/7/08 12:28 PM, "Danny Lewkin" <daniel.lewkin at cognosis.be> wrote:
>
> Hi Danny,
>
>> Hi List,
>>
>> because a concat function returns NULL if one of the fields is null,
>> I thought I could solve this bij :
>>
>> concat(displayname,objptr_typelist,ifnull(objptr_parentid,' '))
>>
>> in which I would add a space instead.
>>
>> But I still keep getting a error on inserting duplicate rows, and I'm
>> certain that objptr_typelist is NOT NULL and has not the same value
>> somewhere else already...
>
> You insert the result of concat into some field which is UNIQUE ?
>
>
> -- 
> Best regards,
>
> Ruslan Zasukhin
> VP Engineering and New Technology
> Paradigma Software, Inc
>
> Valentina - Joining Worlds of Information
> http://www.paradigmasoft.com
>
> [I feel the need: the need for speed]
>
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina