• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Finds in FMP7
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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
References: 
 >Finds in FMP7 (From: Xandra Lee <email@hidden>)

  • Prev by Date: Re: Need help with MS Word 2004 languages and dictionaries
  • Next by Date: Re: Mac OS X 10.4
  • Previous by thread: Finds in FMP7
  • Next by thread: theText is empty
  • Index(es):
    • Date
    • Thread