Efficient way of finding a value

[SteveGriff]

Hi gang,

Just a quickie, because the solution escapes me just at the moment. I have a global field (gproduct_code). What's the most efficient way (i.e - without using a loop script step) to check if my TEXT field called product_code doesn't already have a product code that matches what's in the global field.

Trying to keep fields unique,

thanxs, hope it all makes sense.

Steve Griff.

[Ugo DI LUCA]

create a self-relation g_ProductCode::tProductCode.

Use a calc c_identifyduplicate = Case(Selfjoin::tProductCode > 0; 1; 0)

This will return a 1 if it does already exist.

When processing an entry, your script would simply check the value of c_identifyduplicate.

There are other methods to purge duplicate you might have a look to :

http://www.fmforums.com/threads/showflat.php?Cat=&Board=UBB16&Number=55077&Forum=All_Forums&Words=purge&Match=Entire%20Phrase&Searchpage=0&Limit=25&Old=6months&Main=55070&Search=true#Post55077