I want to create a grid application where the column to return is selected at runtime.
My database looks like :
name | westregionamt | eastregionamt
Bill | 5 | 10
John | 10 | 20
I want the user to be able select the column to view at run time.
My stored procedure works in Mysql Workbench
PROCEDURE Benchmark_Return(in benchmarkselected varchar(45), out benchmarkamount int
IN parameter is benchmarkselected is either westregionamt or eastregionamt
OUT parameter benchmarkamt is then returned
How would I set this up in SC? I tried calling the stored procedure in SQL Preparation
but I don’t see the column available for selection into the grid.
I’m using a stored procedure because I don’t see who I can use a parameter in the Select part of the SQL.
In where, order, group, etc. a parameter of course works, but I can get it to work in the select part,
IE Select $thiscolumn form mydb