New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
SPs in views [CORE886] #1279
Comments
Commented by: Valdir Stiebe Junior (ogecrom) Yes! Enabling us to create a "stored procedure based editable view" will be nice for reducing the ammount of code in client application. |
Modified by: @dyemanovassignee: Adriano dos Santos Fernandes [ asfernandes ] |
Modified by: @asfernandesissuetype: New Feature [ 2 ] => Improvement [ 4 ] |
Modified by: @pcisarWorkflow: jira [ 11122 ] => Firebird [ 14676 ] |
Commented by: Philip Williams (unordained) This issue's (886) priority may be "minor" ... but to me the potential coolness factor is "major". Thanks! Does the existing patch for 2.5 include the ability to do: SELECT ... FROM a ... join ... EXECUTE BLOCK RETURNS (x ..., y ...) AS BEGIN ... END z ON ... and create a VIEW from it? Seems like if we can create a view based on a stored procedure that returns rows, basing a view on an anonymous block that does the same would be logically (if not physically, I'm not saying it'd be easy!) similar ... just curious. |
Commented by: @dyemanov No, there are no plans to support EXECUTE BLOCK inside select expressions. |
Modified by: @pmakowskistatus: Resolved [ 5 ] => Closed [ 6 ] |
Modified by: @pavel-zotovQA Status: No test |
Modified by: @pavel-zotovQA Status: No test => Done successfully |
Submitted by: Michael Trowe (bubble76)
Is related to QA297
Votes: 4
If I want to run a query from a SP with limiting the result-set or with joining other tables, I have to run the query by client or in another SP. But I can' create a view using the SP:
Like:
create view MY_VIEW ( "FIELD_1" )
as
select MY_PROCEDURE."FIELD_1"
from MY_PROCEDURE('...')
The text was updated successfully, but these errors were encountered: