8 Replies Latest reply on Aug 20, 2015 6:35 AM by taylorsharpe

    ExecuteSQL and variables

    dobunzli

      Hello,

       

      I am trying to use "ExecuteSQL" function to obtain linked records (via foreign key). To do that I wish to use a variable in the "ExecuteSQL" function that will contain the id of the initial record.

       

      See attached file as example: i have a table "Artist" and a table "Songs". I want to obtain only the songs for a certain Artist.


      I am using SeedCode ExploreSQL to generate the code to obtain these songs. I am able to obtain all the songs present the database (see script/button "Get song 1") but not the songs linked to a certain Artist (see script/button "Get song 2")

       

      Can someone help me ?

      Thanks in advance.