Re: Finds in FMP7
Re: Finds in FMP7
- Subject: Re: Finds in FMP7
- From: Simon Forster <email@hidden>
- Date: Mon, 2 May 2005 19:45:23 +0100
Bank holdiday weekend here in the UK. Worse, sunny bank holiday weekend.
"Tired and emotional" - so you'll have to work this out for yourself ;-)
--Gets data from FileMaker table fmTable in database fmDatabase based
on idCell name:value pair
--Return data from cell dataCell
--Note: Returns a list of found results if more than one record found
- despite the "first record" qualifier so "first record" qualifier
deleted
--filemakerGetData("Database", "Table", {"raw_name",
"89200"},"raw_backedup")
on filemakerGetData(fmDatabase, fmTable, idCell, dataCell)
try
tell application "FileMaker Pro"
set tableRef to a reference to table fmTable of database
fmDatabase
set criteriaCell to a reference to cell (item 1 of
idCell) of tableRef
set recRef to a reference to (every record of tableRef
whose criteriaCell = (item 2 of idCell))
return get data cell dataCell of recRef
end tell
on error errorMsg number errorNumber from errorObj
error "filemaker.scpt filemakerGetData(fmDatabase, fmTable,
idCell, dataCell). Error message: " & errorMsg number errorNumber
from errorObj
end try
end filemakerGetData
HTH
Simon Forster
_____________________________________________________
LDML Ltd, 62 Pall Mall, London, SW1Y 5HZ, UK
Tel: +44 (0)70 9230 5244 Fax: +44 (0)70 9230 5247
_____________________________________________________
On 2 May 2005, at 14:42, Xandra Lee wrote:
Go absolutely BATTY trying to update scripts to FMP7
Most especially doing finds...
Problem 1: Write access denied: Field in question is an unstored calc.
(didn't have problems with this in earlier FMP versions)
Problem 2: How does one even enter Find mode in an embedded
Applescript
tell application "FileMaker Developer"
go to request 1 --have to do this to enter find mode --
This fails
if in embedded script!!! --Event not handled
set cell "_isFirstofCourse" to "1 "
--> FileMaker Developer got an error: Write access denied.
end tell
end tell
BAFFLED AND FRUSTRATED,
xandra
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Applescript-users mailing list (Applescript-
email@hidden)
Help/Unsubscribe/Update your Subscription:
@ldml.com
This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Applescript-users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden