Page 1 of 1
Can I run stored procedures when adding a new Data Source?
Posted: Tue Dec 10, 2013 12:02 am
by theregister
And if so where would they be located? Would there be a way to add the stored procedures to the dictionary somehow? Or would they have to be a in a database or something?
Re: Can I run stored procedures when adding a new Data Sourc
Posted: Tue Dec 10, 2013 12:27 am
by theregister
I mean when you add the SQL code to the new Data Source, like Selects and such...
Re: Can I run stored procedures when adding a new Data Sourc
Posted: Tue Dec 10, 2013 6:18 am
by Alex K.
Hello,
Yes, it is possible. You can use the Tables, Views, Stored Procedures and your queries as datasource.
Thank you.
Re: Can I run stored procedures when adding a new Data Sourc
Posted: Tue Dec 10, 2013 11:30 pm
by theregister
But can these Stored procedures be declared from within Stimulsoft on the dictionary and not directly on SQL Server?
I ask because if I try to declare a Stored Procedure of a Select for example, it will give me syntax errors when I try to use Stimulsoft variables on the SP, like this:
Code: Select all
CREATE PROCEDURE test
AS
BEGIN
SELECT * FROM {Variable1}
END
Re: Can I run stored procedures when adding a new Data Sourc
Posted: Wed Dec 11, 2013 12:39 pm
by Alex K.
Hello,
This logic (task) is completely incorrect. First, reporting is provided primarily to output information. We do not recommend any changes to the database from the report. Secondly, there is no control of the fact that such a procedure already exists, as well as that there is a table {Variable1}. You need to put this problem in your application, and handle all the possible incorrect options there.
Thank you.