AnsweredAssumed Answered

Strange results using ExecuteSQL and merge variables

Question asked by pthomas on Sep 10, 2012
Latest reply on Sep 11, 2012 by disabled_mr_vodka

I am getting some strange results when trying to use ExecuteSQL to populate merge variables on my layout.


I am using a text field with a let statement in a conditional formatting calculation to assign data to my variables, but it seems that the ExecuteSQL statements aren't always executing.


To confirm that it wasn't something specific to my database I downloaded John Ahn's dynamic value list demo which is using the same technique:


I went to the ID_Values layout, and as I navigate through the records the data on the screen does NOT refresh correctly.


If I go to Records - Refresh Window it fixes up the current record, but when I navigate to the next record it will be wrong again.




I am on record 1 which shows:


I then navigate to record 2 (Note that the ID's on the right side have changed but the names have not) which shows:


Then I refresh the window and it shows:



I am running FileMaker Pro Advanced 12.0v2


I have tried this on both a PC running Windows 7 and a Mac running OS X 10.6.8


Is anyone else experiencing this issue or has anyone found a fix?