Apple

do script FileMaker script "LastRecord"

where" LastRecord" is a FileMaker script to do just that.

Thanks for the help Bruce. While I didn't find the magic words, I learnt more about FileMaker.

On May 8, 2012, at 11:50 PM, Bruce Robertson wrote:

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

References:
	>FileMaker pro changes from v9 to v12 (From: Lists <email@hidden>)
	>Re: FileMaker pro changes from v9 to v12 (From: Lists <email@hidden>)
	>Re: FileMaker pro changes from v9 to v12 (From: Bruce Robertson <email@hidden>)