Enhanced stored procedure support

+4 votes

Can dbFront be modified to support stored procedure output for stored procedures written to return multiple result sets?

I can imagine several use cases for a feature such as this, but for our needs....a simple autoformatted set of displayed tables would be sufficient.

For example, if a stored procedure returned a 3 column data set along with an error/success message, dbFront would display the first dataset as a table, and (I assume) the error message as a second table. That second table would have 1 row and 1 column, and would contain the error message string only.

in Features (Todo) by (160 points)
edited by
A large part of this feature request would revolve around what should be done with the procedure results.  Could I ask you to elaborate on that?  What would you want dbFront to do with the procedure output?
@WesleyHix, I edited your answer into your question.

1 Answer

0 votes

This functionality is not limited to SQL Server so I will definitely consider this as a future enhancement.

NOTE: Please vote on this Feature Request if it interests you.

by (61.1k points)
Welcome to the dbFront Q&A site, where you can ask questions and receive answers from other members of the community.
 | Minimalist Answer Theme by Digitizor Media
Powered by Question2Answer