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 ] ;

 

 

ExecuteSQL

  ("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

 

BUT...it 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?

Outcomes