FileMaker record searching "contains" versus "is e

[jackinva]

Folks,

I've got a problem that I'm hoping someone else has run across with AppleScript and FileMaker 6.

When having a table that contains a field called state which contains values like "Virginia" and "West Virginia", doing whose cell "State" = "Virginia", i.e.

set recordSet to (every record of database "states" whose cell "State Name" = "Virginia" or cell "Variant Region Name" = "Virginia") as list

returns both the Virginia and West Virginia record.

I tried =, is, and equals (is equal to). All return the same result.

Does anyone know how to force FileMaker to do an actual equals and not a contains when selecting records from a FileMaker database with AppleScript?

Thanks,

Jack

[Chuck]

It's not a perfect solution, but you could do something like this:

set recordSet to (every record of database "states" whose cell "State Name" = "Virginia" and cell "State Name" does not contain "West")

[-Queue-]

Try using a double equals "==" for field content match.

[jackinva]

Queue,

Thanks. That's what I was looking for. I posted this question at another forum and got a great explanation with sample code. So you can see that solution at

http://bbs.applescript.net/viewtopic.php?p=17109#17109