Re: FMP5 & Current Record
Re: FMP5 & Current Record
- Subject: Re: FMP5 & Current Record
- From: John MacDonald <email@hidden>
- Date: Fri, 3 Nov 2000 07:58:38 -0400
At 1:47 AM -0500 11/3/2000, James Steincamp wrote:
tell application "FileMaker Pro"
activate
get data of current record of field "Project Number"
end tell
FileMaker uses 'field' to refer to all the records being browsed or
in the database. It uses 'cell' to refer to a record.
You don't need 'activate' unless you want to see what's going on. In
the same vein, you should also 'tell' the database you want to refer
to. By default, FileMaker uses the frontmost window.
So, if your database is called 'Projects', here are some samples:
tell application "FileMaker Pro"
--to get a list of all records in the found set:
set x to field "Project Number"
--this gets the same thing but makes sure you target the correct db
tell document "Projects"
set x to field "Project Number"
end tell
-- use 'database' instead to get all records
tell database "Projects"
set x to field "Project Number"
end tell
-- to get the current record (two methods)
tell database "Projects"
set x to cell "Project Number" of current record
tell current record
set x to cell "Project Number"
end tell
end tell
end tell
As for the clipboard, if you really think you need it, you either
need to use Mac OS 9 (?) or Jon's Commands.
-John
--
--
--------------------------------------------------
John MacDonald
Lab Manager & Macintosh Specialist
Academic Computing Services
Dalhousie University
Dentistry Building, Room 2603
(902) 494-2643
mailto:email@hidden
--------------------------------------------------