Re: filemaker applescript question
Re: filemaker applescript question
- Subject: Re: filemaker applescript question
- From: email@hidden
- Date: Thu, 20 Oct 2005 12:08:08 -0400
> autogen=1 ... + layout etc..
That would be the lesser poison, and it is a solution. Thanks.
You wrote:
Well, you either have to hardcode the FileMaker field names into an
AppleScript, or have a layout which doesn't change in FileMaker. Pick
your poison ;-)
Generally for loading data into FileMaker I'll choose the latter, and
set up a special layout for the purpose. I normally include an
instruction on the layout that an AppleScript is depending on the
layout name and field order.
I choose this method because I've found loading multiple fields at a
time is significantly faster than doing it field-by-field. From your
experience this is probably due to FM doing a 'commit' for each field,
plus having to send multiple Apple Events.
You could also try using the field-by-field method but within a 'with
transaction' statement. Would be interested in your findings.
Another method is to have a flag field in the database which defines an
automatically generated record--i.e.
autogen=1
which is the first field you populate from the AS.
In the database you then turn off the 'require value' option and
instead define a validation calculation along the lines of:
not isempty(my field) or autogen
i.e. You bypass the validation for records loaded from the AS.
_______________________________________________
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