Is it possible to check if a field contains a certain value in any of
the records in my database?

A script in my database is assigning an email address to each new user,
and I would like to be able to check if the field EMAIL (ie.) contains
that address for any of the other records in my database, so as to avoid
duplicates.

Essentially, what I'm looking for is a Perform Find function that
returns the number of records found - and does not display an error
message if that number is zero. What I've done so far is to check each
record with a loop and Get Next Record/Request, but that takes time when
the number of records grow.

--
Thomas Hansen : th(at)ambolt.no : http://www.ambolt.no/

You may try :

Enter Browse mode
Set Field(GlobalField, SearchedValue)
Set Error Capture (on)
Enter Find mode
Set Field( AddressField, GlobalField)
Perform Find (Replace Found Set)
If( Status ( CurrentError ) = 401)
Set Error Capture (off)
Show All Records
End script
End If
Set Error Capture (off)
Set Field(GlobalField, Status ( CurrentFoundCount ))
Show Message( "In the "GlobalField" you have the number of duplicates")

Remi-Noel


"Thomas Hansen" <violon (AT) online (DOT) no> a écrit dans le message de news:
violon-3C3F5E.09341502112005 (AT) sunsite (DOT) dk...

Thanks - that does seem like it would solve my problem.

--
Thomas Hansen : th(at)ambolt.no : http://www.ambolt.no/

You could also place the value in a global field and test a relationship
between that value and the appropriate table to see if it already exists.
This would not require a find, so your current found set would be preserved.
As the number of records increases, it should also be faster.
--
Brent Lewis
Interactive Systems, Inc.
Associate Member, FileMaker Solutions Alliance
http://www.InteractiveSystemsInc.com

"Thomas Hansen" <violon (AT) online (DOT) no> wrote

How about Field options - validation - unique?
Is that too obvious?