AppWorx, Dollar Universe and Sysload Community

 View Only
  • 1.  Applications Manager 9.3

    Posted Jun 23, 2020 11:41 AM
    Hi,

    Looking for a way to prompt a sql script in AM 9.3.  Does anyone know how to do this?

    Thanks,
    Alvin


  • 2.  RE: Applications Manager 9.3
    Best Answer

    Posted Jun 24, 2020 04:14 AM
    do you mean pass prompt values through to a sql script ?

    if so, it's just a case of providing a variable name in the prompt definition and reference that variable within the sql script i.e if the variable name is prompt, then reference &prompt within the script to get the value

    if it's a text value you'll more than likely need to specify a quote char ' on the prompt definition




    ------------------------------
    Cheers
    Pat
    ------------------------------



  • 3.  RE: Applications Manager 9.3

    Posted Jun 24, 2020 08:29 AM
    Hi Pat,

    Thanks, that's the exactly what I was trying to do.  I'll try it out later today.

    Alvin