is it possible to map stored procedure or functon?

BIZ TMS Aurelius
1

Hi,

is it possible to map stored procedure or function in sql server Database?
thanks
2

I'm looking for a similar feature - to be able to map to a view in Firebird - even if only read only, for reporting purposes.There is no support for views in Data Modeler.

3

What you can do is use [Table] attribute and give it the name of a view instead of a table. It should work.

4

what is about  mapping stored procedure?

5

If the stored procedure can be selected as a view, it should follow the same approach? What is your suggestion, how would you want to use the stored propcedure?

6

we use it for reporting purpose, How to pass the parameters?

7

How would you want to pass the parameters? At what point in code? What are the parameter values be based on?

8

How would you want to pass the parameters?

 storedPro.paramByname('ParamName').asstring := value;
 At what point in code?
Before the Execution
What are the parameter values be based on?
Fields Datatypes in the Database

e.g. we have stored procedure in the Database Like :
ALTER PROCEDURE [dbo].[sp_rpt_ChartOfAccount] 
@AccCode Varchar(20),
@FromAccCode Varchar(20),
@ToAccCode Varchar(20),
.
    .
AS
SELECT 
.
.
FROM 
.
.
WHERE
L.Code LIKE @AccCode + '%'
AND L.Code Between @FromAccCode          AND    
@ToAccCode + 'zz'
.
.
.
ORDER BY L.Code
9

I would like to execute this SQL and get the result

Select GetFirstFreePosition(10);

There is a parameter ("10"), but don't know how to pass it to aurelius. Should I just execute this via normal DB components?

10

No, only parameterless stored procedures. There is no way to pass parameters to stored procedures in Aurelius as if they were tables.

1 Like