Re: Filemaker (Pro Advanced 8) bug?
Re: Filemaker (Pro Advanced 8) bug?
- Subject: Re: Filemaker (Pro Advanced 8) bug?
- From: Peter Baxter <email@hidden>
- Date: Mon, 23 Oct 2006 20:12:57 +1000
Hi David,
Just a few comments on Applescript and Filemaker Pro,
Based on a great deal of development using both applescript and
Filemaker, It is always faster and more reliable to create your
script within Filemaker applications and call them from Applescript.
Therefore the fastest and most reliable way to achieve what you want
is through a Filemaker script creating the new record without going
to the layout, and then calling that script externally. A simple
script such as the one you describe will have no problems, but more
complex scripts can often produce unexpected results.
This is why I suggested that freezing the window before creating the
new record would be the best approach. You don't then need to leave
the current screen.
Another approach is to have a global field called something like
layoutPrevious and set the name of your current layout in it at the
start of the script and then go to that layout by calling it at the
end. I have seldom noticed any discernible delay in either method
when dealing with 4,000 - 5,000 records in a database of up to 150
layouts.
If you notice a slowing of the database, it might be worth looking at
indexing the fields that are involved in the layouts you access.
Here is part of a script you could call "New"
Set Field [zGlobal::gLayoutPrevious; Get (LayoutName)]
Go to Layout ["CourseDetail" (Course)
New Record/Request
Go to Field [course::courseTitle
Go to Layout [zGlobal::gLayoutPrevious
Your Applescript just calls this script. End of problem.
_______________________________________________
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/mailman//archives/applescript-users
This email sent to email@hidden