Re: FileMaker Create Record Target
Re: FileMaker Create Record Target
- Subject: Re: FileMaker Create Record Target
- From: Peter Baxter <email@hidden>
- Date: Thu, 12 Jun 2008 22:25:30 +1000
Why not tell Filemaker to open your target database first. This will
ensure that it is the front
most database.
On 12/06/2008, at 2:28 PM, Bruce Robertson wrote:
The following script will create a record in the frontmost database.
How can I target the correct database?
I am using FileMaker Pro Advanced 9v3
tell application "FileMaker Pro Advanced"
tell database "Marketing Landscape.fp7"
tell table "Calendar"
tell layout "Calendar List"
-- show
set vNewRecord to create new record with data
{vEventName, vDaysLateMax, vEventLocation, vProjectStartDate,
vStartDate,
vEndDate}
end tell
end tell
end tell
end tell
Thanks,
Jason Bourque
Your script is a little schizoid because of the difference between
table and
layout.
A table is the underlying data source.
A layout is based on a table. If you target a layout then data will be
created in the table the layout is based on, in the field order of the
layout.
If you target a table data will be created in creation order of the
fields.
I'd skip the table in your case.
tell application "FileMaker Pro Advanced"
tell database "Marketing Landscape.fp7"
tell layout "Calendar List"
-- show
set vNewRecord to create new record with data {vEventName,
vDaysLateMax, vEventLocation, vProjectStartDate, vStartDate, vEndDate}
end tell
end tell
end tell
_______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list (applescript-
email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users
This email sent to email@hidden
"Those who would give up essential liberty to purchase a little
temporary
safety deserve neither liberty nor safety."
--Benjamin Franklin, 1759
Peter Baxter
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:
Archives: http://lists.apple.com/archives/applescript-users
This email sent to email@hidden