Re: Find in Filemaker 6
Re: Find in Filemaker 6
- Subject: Re: Find in Filemaker 6
- From: Malcolm Fitzgerald <email@hidden>
- Date: Wed, 16 Mar 2005 10:20:13 +1100
On 16/03/2005, at 9:04 AM, Bernardo Hoehl wrote:
Hi List!
I have this string that I am already able to generate:
"≥01.03.2005≤31.03.2005"
(first day of this month to last day of this month expressed in a
brazilian format)
I need to perform a find in the record's date of creation cell (or
field?) with this string, by just pressing a button.
But it seems I don't quite understand the difference between "cell"
and "field", and not understand what a "request" is.
The record is the row, one bit of every field in the database.
The field is the column, every bit of one category of data, such as
first names.
a cell is the intersection of the row and the column.
I get many messages of errors saying that the cell can not be written
or the data is invalid.
Can you help me by writing me an example line of AppleScript that will
do the equivalent of:
Entering my Filemaker app into "Find Mode" and inserting the above
string in the creation date cell (or field?) and hitting enter?
Filemaker is fussy about what you put into date fields. I use the short
string format day/month/year (for Australian dates) which filemaker
accepts in date fields. I've also found problems when using filemaker
scriptmaker, in find mode, filemaker won't allow you to use "set" for
the string you're using, it accepts "insert calculated result" or "go
to field/paste".
Gil Dawson just posted this solution in another thread.
set mthBegin to "01.03.2005"
set mthEnd to "31.03.2005"
tell application "FileMaker Pro"
show (every record whose ¬
cell "date creation" is less than mthEnd and ¬
cell "date creation" is greater than mthBegin)
end tell
it should be relatively fast because it sends only one apple event. The
alternative has to send four apple events so it has an immediate
handicap:
tell application "FileMaker Pro"
tell database 1
try
delete every request
end try
set theRequest to create new request
set cell "creation date" of theRequest to vItemNumToFind
find
end tell
end tell
Malcolm Fitzgerald ph: 02 93180877
Database Manager fax: 02 93180530
The Australian Society of Authors www.asauthors.org
_______________________________________________
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