Broken FM Applescript on conversion

[agutleben]

HELP!!! :

I have a converted solution that uses AppleScript to send emails via Entourage.

It seems to fail when trying to pass a value back to FileMaker. Here's the original applescript code where the failure is occurring:

set cell "g_num" of (current record of database "Correspondence.fp5") to theValue

I played around a little and found that if I changed it to something like this:

set field "g_num" of table "Correspondence" of database "Correspondence" to theValue

I have been able to create a scratch file where I get this to work, but I can't seem to pass a value back to the hosted "converted" file.

Any help would be greatly appreciated!

TIA,

Aaron

Edited August 12, 2010 by Guest

[bruceR]

Why did you change "cell" to "field"?

In both old and new versions, a field is an entire column -all records in found set or all records in database depending on more details of the reference. A cell belongs to a single record.

[agutleben]

Grasping at straws really. It's a global field, so it shouldn't matter should it?

[agutleben]

Scratch that.. I see it does matter. It appears that "set field" will update all records, whereas "set cell" operates against the record you are on. While a global field does contain the same value for all records, I can't wait for all rows to be processed.. Changing to set cell on the line I was playing with did the trick.