Re: Find in Filemaker 6
Re: Find in Filemaker 6
- Subject: Re: Find in Filemaker 6
- From: Bernardo Hoehl <email@hidden>
- Date: Tue, 15 Mar 2005 22:11:50 -0300
Hi Malcom.
Thank you for for detailled explanation.
You have been very helpfull in my learning.
Bernardo
++++++++++++++++++++++++++
On 15 Mar, 2005, at 8:20 PM, Malcolm Fitzgerald wrote:
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:
email@hidden
This email sent to 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:
This email sent to email@hidden