Hi everybody, I’m new here and I have a big doubt, I made an adapter service in which I have to receive an input parameter and I declared an input field called Department_ID, the problem is that I don’t know how write the SQL Query (a Select) because when I try to run it appears me an syntax error message.
Please if somebody knows the correct syntax, could you help me?
Select: the rows you wanted to select from the table
Where: Select the column conditions. Here is where you have declare the input parameters. At the below block you find the creation of Input parameters. And be carefull of selecting the types ( use java.lang.string - only type understood my webMethods ). In the upper block( giving the conditions for a particular column, leave a ‘?’ in the input field, if you want to get tat value at the run time. And also the order of the parameters used here must be in the same order of the Input Parameters declared in the bottom block.
Input/Output: Here you find the input parameter created in the above step.