error 537860 "unique violation"

[Olivier]

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