Stored Procedure Usage tips?
I deal with a software/db product that is older than I am (I am 36) .....
I have zero control of the DB side of things. I get what I am given.
A LOT of calls are stored procedure based.
It amazes me there is no built in stored proc support yet in the data tab.
Is there any reason for this?
I can get by mostly writing query in the code page, do to a CALL but man is it messy. As I have alot of calls... with alot of params.
My other big issue is some calls return no dataset. Just a return value parameter. I can't figure out how to deal with those in fast reports.
So I have to do code that runs some stored procs... and passes those to the report as variables. Would LOVE to have just all that stuff shoved into the
report it self. Apparently this stuff worked in Crystal Reports... not 100% sure as I never used it, but told it did...
This puts a big strain on me having to do alot of work arounds.
I have zero control of the DB side of things. I get what I am given.
A LOT of calls are stored procedure based.
It amazes me there is no built in stored proc support yet in the data tab.
Is there any reason for this?
I can get by mostly writing query in the code page, do to a CALL but man is it messy. As I have alot of calls... with alot of params.
My other big issue is some calls return no dataset. Just a return value parameter. I can't figure out how to deal with those in fast reports.
So I have to do code that runs some stored procs... and passes those to the report as variables. Would LOVE to have just all that stuff shoved into the
report it self. Apparently this stuff worked in Crystal Reports... not 100% sure as I never used it, but told it did...
This puts a big strain on me having to do alot of work arounds.
Comments
No one uses Stored Procs I take it?