Re: Filemaker Pro chokes on Find command
Re: Filemaker Pro chokes on Find command
- Subject: Re: Filemaker Pro chokes on Find command
- From: Jake Pietrykowski <email@hidden>
- Date: Wed, 01 Jun 2005 09:08:22 -0500
Eric,
I experience the same issues. Haven't pinned it down as to WHY the 'find'
script command does not execute from AppleScript inside of FileMaker, rather
when outside of FileMaker...all works perfectly.
None the less, there is an EASY fix. Create a NEW FileMaker script and name
it 'performFind'. Add the FileMaker command 'Perform Find' to the script.
Deselect the 'Restore Find Requests' checkbox, and leave set to 'Replace
Found Set'.
Now...in your script just replace the 'find' command with 'do script
"performFind". Viola!
I've found this some time ago, and I find it to be an intermittent problem.
I always use this 'do script', it ALWAYS works. I'd imagine that is why some
users posted success when attempting to find.
--code
tell database "database.fp5"
show every record
delete every request
create new request
set cell "cellName" of request 1 to "12/1/2004...12/20/2004"
do script "performFind"
end tell
--/code
Best Regards,
Jake
On 5/31/05 2:33 PM, "Eric Geoffroy" wrote:
> Hi all,
>
> Thanks for the tips. Here's what I tried so far-
>
> 1. Adding another "find" at the end.
> 2. Changing the "request -1" to request 1 (there's only one request in
> my test)
> 3. Turned off smart quote marks in FMP 6 document prefs.
>
>
> I'm still getting stuck in Find mode. I'm happy to try any other
> suggestions out.
>
> - Eric
>
>
> On May 26, 2005, at 12:01 PM, kai wrote:
>
>>
>> On Thursday, May 26, 2005, at 04:30 pm, Gary (Lists) wrote:
>>
>>> "kai" wrote:
>>>
>>>>> From my previous dealings with FMP, the culprit could well be
>>>>> FileMaker itself. Somewhere in the application preferences
>>>>> ('Document.../General' in the good old days, IIRC), there was a "Use
>>>>> smart quotes" option...
>>>>
>>>> To double-check this, I just went back to an old copy of FMP (4.0v1),
>>>> running on OS 9.1, but couldn't replicate the problem. So maybe I was
>>>> recalling a setup even earlier than that - or perhaps it was just
>>>> another episode of delirious raving(!) Best disregard... ;-)
>>>
>>> No, it's there (he said, hopefully.) Though I am not looking as I
>>> type,
>>> there are 'Application Preferences' and 'Document Preferences'. I
>>> _believe_
>>> that this setting is in Document preferences, so if you didn't open a
>>> DB you
>>> may have missed that.
>>>
>>> At any rate, in FM5 and FM6 (and I do think FM4, but...) it's in one
>>> set and
>>> not the other.
>>
>> Ah yes - just as I recalled. Thanks, Gary. :-)
>>
>>> And if AS were being run from a Field, as is common, then this
>>> _would_ be a
>>> problem. If the AS is in a Perform AS script step, then I don't
>>> think it
>>> would even compile in there, but...
>>
>> Right. It returns the old "found unknown token" compile time error,
>> here - as one might expect.
>>
>> Anyway, while checking that, I thought I'd go back to the Eric's query
>> - to see if I could replicate the condition that he first described.
>> Turns out that I get similar behaviour - except that it's not actually
>> Find mode I get stuck in. It's in FMP's script execution, as if the
>> script has been paused.
>>
>> If this what Eric was trying to describe, then I may be able to
>> suggest a fix, which simply involves repeating the find command -
>> something like this:
>>
>> ------
>>
>> delete every request
>> set (create new request)'s cell "date" to "5/1/20055/30/2005"
>> find
>> find
>>
>> ------
>>
>> Of course, Eric's problem may be something else entirely - but I
>> thought it worth mentioning.
>>
>> ---
>> kai
>>
>>
>
> _______________________________________________
> 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
_______________________________________________
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