AnsweredAssumed Answered

Error in ExecuteSQL query just under MAC

Question asked by vatorin on Mar 2, 2018
Latest reply on Mar 2, 2018 by user19752

Good day.

The script step produces a void in Filemaker pro 16 on the MAC OS if there is more than one value.

If there is 1 value in the list it works correctly.

In Filemaker pro 16 on Windows produces the correct results.

 

Let ( [

           Sales = Sales Order Title::Order ID;

           SQL = ExecuteSQL (

                                   "

                                        SELECT  c.\"Id Manufacturer\" ,  a.\"Product Id\"  ,   a.\"Number\"

 

                                        FROM \"Sales Reserve\" a

                                        JOIN  \"Products\" b ON a.\"Product Id\" = b.\"Products ID\"

                                        JOIN  \"Manufacturer TM\" c ON b.\"Id TM\" = c.\"TM ID\"

                                        WHERE  a.\"Batch Id\" IS NULL  AND a.\"Initiator Id\" = ?

                                        Order by  c.\"Id Manufacturer\"

                                  "

                                             ; "|" ; ¶ ;

                                             Sales

                                            )

] ;  SQL

       )

Outcomes