469,924 Members | 1,392 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,924 developers. It's quick & easy.

define variables

Hi,
I want to make a dynamic comparison in order to find out all the duplicates
in the table. Becuse the data is not so tidy, and sometime the strings have
a little difference but still a duplicate, I don't compare with this field.
In this case, I have to select those fields that don't have so much
confusion.

In short, I have a table containing field1, field2 ... fieldn :' "n" is a
variable
I want to make a comparison to next record by the fields selected, NOT all.

For example:

if fileld1 is selected then
Ffield1 = rs("fileld")
end if

if fileld2 is selected then
Ffield2 = rs("fileld2")
end if
....
if fileldn is selected then
Ffieldn = rs("fileldn")
end if

'when the recordset move next

if fileld1 is selected then
Sfield1 = rs("fileld1")
end if

if fileld2 is selected then
Sfield2 = rs("fileld2")
end if
....
if fileldn is selected then
Sfieldn = rs("fileldn")
end if

' now do comparison

if Ffield1 = Sfield1 and Ffield2 = Sfield2 and ... Ffieldn = Sfieldn then
' also get rid of those unseleted fields in above statement.
'if field4 is not selected, then no Sfield4 defined, and no value.

'do whatever I want here.

This may not be a good solution, but I don't have a better one. Can anyone
provide me a share idea? Or let me know how to figure out the problem above.
Thanks a lot.

Atse
Jul 19 '05 #1
0 2136

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by axial | last post: by
12 posts views Thread by David WOO | last post: by
8 posts views Thread by Fan Zhang | last post: by
6 posts views Thread by msigwald | last post: by
2 posts views Thread by JIM.H. | last post: by
5 posts views Thread by MoslyChang | last post: by
1 post views Thread by Bryan Parkoff | last post: by
3 posts views Thread by Immortal Nephi | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.