Re: Filmaker container field
Re: Filmaker container field
- Subject: Re: Filmaker container field
- From: Ilyse Kazar <email@hidden>
- Date: Tue, 13 Aug 2002 22:52:15 -0400
At 10:38 AM +1000 8/13/02, Kelvin Aitken wrote:
>
In Applescript how do I ascertain if a container field in FileMaker
>
contains information (a picture to be
>
precise)?
>
>
I have a script that checks a Filemaker database to see which records
>
do not contain pictures in the
>
picture container field but am having trouble nutting out how to get
>
a boolean result on whether a
>
container field is empty or not.
Would it work for you to write the Boolean calc in FMP?
IsEmtpy(ContainerFieldname)
would return 1 if true. If you index that calc, you could use a
relationship in FMP from a global number field set to 1 and the Boolean
calc to very rapidly (via the Go To Related Records/Show command)
isolate a found set of records that do not have any contents in the
container field. Then let your Applescript do what it will with those
records.
(just an AppleScript lurker, but always glad to help with an FMP issue)
kazar
--
Datatude(R) consulting services
<
http://www.datatude.net/>
_______________________________________________
applescript-users mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/applescript-users
Do not post admin requests to the list. They will be ignored.