Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB Enhancement Requests and Suggestions » View Thread |
Messages 1 to 2 of 2 total |
Allow Stored Procedure that returns a result set to be accessed via SELECT statement |
Tue, Jun 10 2014 6:18 AM | Permanent Link |
Adam Brett Orixa Systems | If you have a Stored Procedure (i.e. "CurrentStocks", returning all data on stock-levels from a DB) it would be great to be able to write:
SELECT * FROM CurrentStocks Of course EDB would have to check that the procedure returned a result set during the prepare. I realise this raises security issues (Stored Procedure could include dangerous code), but I think it would be valuable. |
Tue, Jun 10 2014 7:07 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Adam
>If you have a Stored Procedure (i.e. "CurrentStocks", returning all data on stock-levels from a DB) it would be great to be able to write: > >SELECT * FROM CurrentStocks > >Of course EDB would have to check that the procedure returned a result set during the prepare. > >I realise this raises security issues (Stored Procedure could include dangerous code), but I think it would be valuable. Are you looking for a VIEW? The difference is that you can't pass parameters into a view. Roy Lambert |
This web page was last updated on Thursday, March 28, 2024 at 08:36 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |