I experienced a serious problem with FileMaker Pro 8 while testing.
This works with FMP from 4.x to 6.x if “table” has been replaced with “layout”
tell application "FileMaker Pro"
set _id1 to cell 1 of table 1 of database 1
set _id2 to cell 1 of last record of table 1 of database 1
set _id3 to cell 1 of current record of table 1 of database 1
return {_id1, _id2, _id3}
end tell
But in FMP 8 accessing “current record” following the object model exactly does not work anymore! “last record” works instead.
Did anyone make the same experience and is able to deliver a workaround?
I’m experiencing the same issue. It seems that current record is not related to the table or layout item.
_id3 works, but is the absolutely valid current record. It implies a global validity of the current record over all tables.
Otherwise replace database with window and table with layout (_id4).
Feature? :rolleyes:
tell application "FileMaker Pro Advanced"
set _id1 to cell 1 of table 1 of database 1
set _id2 to cell 1 of last record of table 1 of database 1
set _id3 to cell 1 of current record of database 1
set _id4 to cell 1 of current record of layout 1 of window 1
return {_id1, _id2, _id3, _id4}
end tell
Orso
P.S.
I also take the chance to warn that cellValue returns styled text under FM 8.
It didn’t at least under FM 6.
There might be circumstances where this is not wished.
Model: PowerBook g4, 1500
AppleScript: 1.9.3
Browser: Safari 312.6
Operating System: Mac OS X (10.3.9)
