Re: FileMaker pro changes from v9 to v12
Re: FileMaker pro changes from v9 to v12
- Subject: Re: FileMaker pro changes from v9 to v12
- From: Bruce Robertson <email@hidden>
- Date: Tue, 08 May 2012 23:50:33 -0700
Two more examples.
Being specific; and using references often works well with applescript, such as in this case:
property theDBsName : "MailingLists.fmp12"
property layoutName : "AppleScriptLists"
tell application "FileMaker Pro Advanced"
set tblRef1 to a reference to table "AppleScriptLists" of database theDBsName
tell layout layoutName to show every record of tblRef1
-- works
tell layout layoutName to show every record of table "AppleScriptLists" of database theDBsName
-- doesn't work
end tell
On May 8, 2012, at 1:25 PM, Lists wrote:
> Interesting. Thanks Bruce.
>
> The lines I posted were from a script that has worked since FileMaker added tables to the containment hierarchy (FMP7 I think).
>
> If I remove the line "tell table "MyData" of database theDBsName to show every record" then the records added in the previous line stay hidden and I have to Show All Records to get them. That may be broken but it works here and has for years.
>
> The problem line, "tell table "MyData" of database theDBsName to go to newrec" worked in FMP9 until two days ago when I upgraded to FMP12.
>
> I tried several iterations of what you suggested, telling layout x of window y of database blah in as many ways as I could think of. None worked although a couple took me to the first record in the db but not the last.
>
> Any suggestions?
>
> Thanks
> Joe
>
>
> On May 7, 2012, at 12:39 PM, Bruce Robertson wrote:
>
>>
>> On May 7, 2012, at 12:02 PM, Lists wrote:
>>
>>> Yesterday I upgraded FileMaker Pro to v12 from v9. Everything seems fine except this:
>>>
>>> This worked in FMP9:
>>>
>>> tell application "FileMaker Pro"
>>> set newrec to create new record with data tempDataList at table "MyData" of database theDBsName
>>> tell table "MyData" of database theDBsName to show every record
>>> tell table "MyData" of database theDBsName to go to newrec
>>> end tell
>>>
>>> The last tell, "tell table "MyData" of database theDBsName to go to newrec" no longer works.
>>>
>>> Does anyone know how to go to the last created record in FMP 12?
>>>
>>> Thanks
>>> Joe
>>
>> Tell table to show anything has never worked.
>>
>> Only a specific layout in a specific window can have a found set, current record, sort order, etc.
>>
>> Bruce Robertson
>
_______________________________________________
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/archives/applescript-users
This email sent to email@hidden