is there a way to call a stored select stored procedure from scriptcase and return to a grid.
call data(’@date’,’@date2’);
I think you must create the table with same structure what return el stored procedure.
then create your grid app with this table.
Then test if can call your stored procedure from section SQL.
SQL Preparation
You can enter SQL commands or procedure names to execute them before the primary SQL of the application.
Tables not the same after each call - and its too big for a temp table - 2000 lines. Its returning daily investment growth over 2 years for multiple products, - pivot table style.
I think a APP GRID should have an associated table. so you should try to use DATATABLES, so you can use dynamics SQL:
https://datatables.net/
in the sql preparation put the call data(’@date’,’@date2’) that truncate and insert all 2000 lines of data, then the SQL select from that table. If data are different for other parameters or the user then in the data table add a field session. Then to the function data gives all the parameters plus the sessionid.
Then instead of truncate just delete from table based on session id, insert with session id and then select with sessionid, so every user see their data.
If table grows too much, add a datetime field to records, with default values is currettimestamp, then add a delete from the table when data is older than 1 day, so it will keep the table with few records.