Sender: |
|
Date: |
Wed, 11 Jun 2008 17:16:03 -0400 |
MIME-version: |
1.0 |
Reply-To: |
|
Content-type: |
text/plain; charset=US-ASCII; format=flowed; delsp=yes |
Subject: |
|
From: |
|
In-Reply-To: |
<p06230900c475e8bd4834@[128.253.187.23]> |
Content-transfer-encoding: |
7BIT |
Parts/Attachments: |
|
|
Bill,
I don't have FMP to test , you might be able to query the cell value
in the find, but you can definitely do the find.
set yourVariable to "1234456"
tell application "FileMaker Pro"
tell database "your_db_name"
set findResults to ID of (every record whose cell "somefield" is
yourVariable)
repeat with thisRecord in findResults
tell record ID FMPRecordID
set wantedData to {recordDescription:cell "description",
recordOtherData:cell "OtherData"}
end tell
end repeat
end tell
end tell
Paul
On Jun 11, 2008, at 4:53 PM, Bill Steele wrote:
> This ought to be the most basic, simple thing you could possibly do,
> so I'm probably missing something obvious. I want to get the value
> of a particular cell from a record that matches something in another
> cell.
>
> In SQL, something like
> select phone_number from people where name = "Smith"
>
> so why not
>
> tell database "people"
> get cell "phone_number of every record whose cell "name" is "Smith"
> end tell
>
> -->Object not found
>
> Tried get data, show, find, goto, and so on. Always an error.
>
> Every reference on Applescripting Filemaker I've looked at has
> offered vast detail on how to get field names, table descriptions,
> yadda yadda. Not a word about just finding data.
> --
>
> Bill Steele
> [log in to unmask]
|
|
|