capsprojectos

Duplicate without scripts isn't working.

3 posts in this topic

Hello Filemaker experts,

 

I am trying to do a simple task without using scripts, but isn’t working and I don’t understand why.

.       I want to find duplicates in this Filemaker attached, the fields are as Unicode, the others types are worst.

 

Correct Answer: zero (there isn’t duplicates)

 

#Try1 – Perform find ! (oki::duplicated): Error 128 records;

#Try2 – Base64 encode:; Perform find ! (oki::base64):  Error 128 records;

#Try3 – Using relationships with (oki::duplicated): Big mess (4 records duplicated); Can understand why?

#Try4 – Using relationships with (oki::base64): Big mess ( 31~42 records duplicated); Can understand why?

 

Thanks for your support and suggestions,

 

Duplicated.fmp12

Share this post


Link to post
Share on other sites

Use and MD5 checksum field. (Result is text)

checksum.png

1 person likes this

Share this post


Link to post
Share on other sites

Hello Bruce,

Thank you very much, I never thought about using "MD5".

Much appreciated

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now