error 537860 "unique violation"

[Ruslan Zasukhin]

On 1/20/05 12:08 PM, "Olivier" <vidal_olivier at yahoo.fr> wrote:

Oliver,

Please put this bug into Mantis

And can you send some project that reproduce this problem.
I think tip here that method marked as unique.

> Hi Ruslan and list,
> 
> I have in my DB :
> 
> table.constructor
> 
>    string1=new vstring("string1",5,EVflag.fIndexed)
>    string2=new  
> vvarChar("string2",100,EVflag.fIndexed+EVflag.findexByWords)
>    string3=new  
> vvarchar("string3",105,Evflag.fIndexed+EVflag.funique,"CONCAT(string1,st
> ring2)")
> 
> thus,
> - string1 = indexed
> - string2 = indexbyword
> - sting3 = (string1+string2).unique
> 
> record1 :
> 
> string1 = "75001"
> string2="PARIS"
> string3="75001PARIS"
> 
> if I try to add the same record, I have the error 537860 "unique
> vilation" and not the error 144643.
> if I catch this error (537860), error is catched BUT the ROW RECORDING
> ALL THE SAME.
> 
> thus, I have :
> 
> record1 :
> 
> string1 = "75001"
> string2="PARIS"
> string3="75001PARIS"
> 
> record2 :
> 
> string1 = "75001"
> string2="PARIS"
> string3="75001PARIS"
> 
> 
> Olivier
> 
> _______________________________________________
> Valentina-beta mailing list
> Valentina-beta at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina-beta

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------