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?