AnsweredAssumed Answered

ExecuteSQL in Set Variable issue

Question asked by dtcgnet on Aug 1, 2016
Latest reply on Aug 2, 2016 by dtcgnet

I have a statement in my startup script that sets a global variable called $$AccountID.


The formula is:


Let (

[ UserAcctName = $$UserAccountName ] ;




  ("SELECT XP_ID FROM Personnel P

WHERE P.SoftwareUserName = ?" ; "" ; "" ; UserAcctName )



This step works perfectly well when I access my solution via:

1) FileMaker Pro

2) FileMaker Go on an iPhone

3) FileMaker Go on an iPad

4) WebDirect in Safari

5) WebDirect in Google Chrome does not work at all when I access my solution through Safari using WebDirect on my iPad or iPhone.


It works fine in WebDirect on a computer. It does not work in WebDirect on my iPad.


Any suggestions?