access to scripts names via SQL

Idea created by jrenfrew on Oct 27, 2015
    Active
    Score7
    • jrenfrew
    • Benjamin Fehr
    • monkeybreadsoftware
    • Vincent_L
    • TimAnderson
    • Markus Schneider
    • Fred(CH)

    Context:

    At the moment the only way to dynamically get a script name to use in an FMP URL is to go into the script with a global variable set, and exit immediately with Get ( ScriptName)

     

    Idea:

    ExecuteSQL( "SELECT ScriptName, ScriptID FROM SCRIPTS WHERE File = ? " ; "" ; "" ; $fileName)

    Then we could use an internal ID for the script to grab it's name and dynamically populate an FMP uRL which allows for dynamic navigation schemes