Skip to Content
0
Former Member
Apr 11, 2007 at 10:56 AM

Using output parameters of a SQL stored procedure

30 Views

Hello everyone

I have a problem with the output parameters of a SQL stored procedure. I have a SQL table with statistical data. One column is of type date. I want to create a Visual Composer application that displays some aggregated data depending on a selected time period. So I created a normal table that is connected to the result field of my table select stored procedure. I created an input form with two calendars where I can select a start date and an end date and connected the calendars to the input parameters of the table select stored procedure. Everything works fine until this point.

Now I want to improve the user friendliness and preselect the min max dates of my statistic table. I wrote a minmax stored procedure that calculates the min date and the max date of my statistic table and returns the two values as output parameters. When I add the minmax stored procedure as data service the output parameters are recognized as inout fields. When I connect these inout fields to my input form nothing is displayed. It seems that those min max values are not received.

Has anyone an idea why I cannot display these min max values?