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

[Ruslan Zasukhin]

on 10/3/03 1:40 AM, Cindy at alvin at ins.co.nz wrote:

> 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.

Yes, this can work.

Florian, you use this with vserver correct?
So I think you will need to use server-side cursor for this loop.

And SELECT only 2 fields into cursor, name and lname. May be RecID also.
Then you will send by network only this 2 fields.

-- 
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
-------------------------------------------------------------