AnsweredAssumed Answered

Basic ExecuteSQL question

Question asked by rodwright on Apr 20, 2018
Latest reply on Apr 21, 2018 by rodwright

Newbie FileMaker user here. I have written numerous SQL statements using other databases. I need to use a SQL statement that will return multiple values. My Select will be something like

 

ExecuteSQL ( "SELECT EmpID, EmpName FROM Employees"; ""; "" )

 

I have seen many examples showing this being placed in a script as

 

Let ( $Result = ExecuteSQL ( "SELECT EmpID, EmpName FROM Employees"; ""; ""; ) )

 

So now $Result will have a value of something like

 

1234,John Jones¶1235,Janice Mably¶1236,Bryan Smith¶

 

What I haven't found is the text function to break $Result down so that I can use the actual values returned by the ExecuteSQL. Would someone please enlighten me?

Outcomes