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:

 

http://www.filemakerhacks.com/?p=5357

 

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.

 

e.g.

 

I am on record 1 which shows:

Capture.PNG

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

Capture.PNG

Then I refresh the window and it shows:

Capture.PNG

 

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?

 

Cheers,

 

Paul.

Outcomes