AnsweredAssumed Answered

FileMaker 12 ExecuteSQL and valuelist popupmenu parameters?

Question asked by LukeWallace on Sep 23, 2012
Latest reply on Sep 24, 2012 by philmodjunk

Title

FileMaker 12 ExecuteSQL and valuelist popupmenu parameters?

Post

     Ok, I have a popupmenu with 3 options (System1, System2 and System3)

     I'm new to FileMaker but I believe you guys call this a valuelist?

     I also am using a executesql function that looks like this:

      

     
NOTWORKING:
     
           
     
          SELECT DISTINCT a."System"
     
          FROM "CommercialLight" a
     
          WHERE a."System" LIKE popupmenuitem
      
     
WORKING:

               SELECT DISTINCT a."System"
               FROM "CommercialLight" a
               WHERE a."System" LIKE System1
                
WORKING:

                    SELECT DISTINCT a."System"
                    FROM "CommercialLight" a
                    WHERE a."System" LIKE System2
                     
WORKING:

                         SELECT DISTINCT a."System"
                         FROM "CommercialLight" a
                         WHERE a."System" LIKE System3
      
      
      
     Now, if I replace "popupmenuitem" with either System1, System2, or System3 it will work, but I have to do it manually.
     It would be nice to be able to change this argument, or parameter, or whatever it's called on the fly by a nice drop down menu so an end user can specify the type of executesql they want to run without knowing how to read and modify sql code..
      
     To do this, "popupmenuitem" has to be able to read whatever value they select from the pop up menu in browse mode, but I don't know how to code this, any ideas?

Outcomes