access to scripts names via SQL

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


    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)



    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