Uploaded image for project: 'Apache Hop (Retired)'
  1. Apache Hop (Retired)
  2. HOP-3488

Execute SQL Script - Parameter selection not possible

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Minor
    • Resolution: Won't Fix
    • 1.0.0
    • Not applicable
    • Transforms
    • None
    • Windows 10
      hop-gui.bat
      hop v1.0

    Description

      It is not possible to select parameters for the action "Execute SQL Script" when using hop-gui.bat v1.0. 

      "Bind parameters" checkbox is disabled and its not possible to add parameters to the Parameter selection area. 

      If the used stream field does not have to be explicitly specified anymore but can be referenced simply by name ?param_int please remove the param selection and change the docs.
      Otherwise please fix.
       

       

      current doc for Parameters:

      Parameters The list of used parameters that will replace the question marks in the query in the given order. So the first question mark will be replaced by the first parameter, the second question mark by the second parameter etc.

       

      Possible workaround:

      using the Execute row SQL script with an "User defined Java expression" before to generate the SQL  

      Attachments

        1. image-2021-11-07-21-25-30-735.png
          7 kB
          Nicolas Adment
        2. image-2021-11-12-07-27-16-931.png
          56 kB
          Peter Janz

        Issue Links

          Activity

            People

              sramazzina Sergio Ramazzina
              peter.janz Peter Janz
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: