AW: AW: AW: V4MD Looking for ideas and solutions forsearchingdoubleentries

[Florian Bogeschdorfer]

It is a way Cindy, thank you. But it takes a lot of time when you do this
with 10000 records just to find the 50 doubles :-(  And it will not realize
double entries with a missing char or a double char or naem istead of
name...

I am developing my double search now with adding a kTypeUShort for 'name'
and 'vorname' ... Where I keep the sum of the ASCII chars of the string
fields and then compare the sum values against each other. This way 'naem'
is a double of 'name' and the user may define a range so the search will
recognize 'longname' as a possible double of 'llongname' for example

Best regards, Florian

> -----Ursprüngliche Nachricht-----
> Von: valentina-bounces at lists.macserve.net 
> [mailto:valentina-bounces at lists.macserve.net] Im Auftrag von Cindy
> Gesendet: Freitag, 3. Oktober 2003 00:41
> An: Valentina Developers
> Betreff: Re: AW: AW: V4MD Looking for ideas and solutions 
> forsearchingdoubleentries
> 
> Don't know if this will help, but if I am checking double 
> entries I do a select on all the database sorted by last 
> name, first name. Then I loop through the select putting the 
> combination of the last name and the first name into a 
> string. I then check the string against the last name and the 
> first name of the next record. If they are the same, I leave 
> them, if they are different, I drop the first record. This 
> would probably need some refining but should give the general idea.
> 
> Hope that helps.
> 
> Cindy
> 
> > 
> >> 
> >> Florian, please note, Ivan describe solution for Oracle, not for 
> >> Valentina !!!
> >> 
> >> In Valentina 1.x above SQL not works.
> >> 
> > So you don't think there is an "easy" solution for Valentina?
> > 
> > Best regards, Florian
> > 
> > _______________________________________________
> > Valentina mailing list
> > Valentina at lists.macserve.net
> > http://lists.macserve.net/mailman/listinfo/valentina
> > 
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina