Setting Database environment variables

mortega

Hi there;

I'm a few days evaluating fast report; using it with C#/MVC/ RAZOR;

I already read programmer's manual and search lot (this forum using google) ; and no results for this case;


I want to execute one stored procedure every time FastReport connect to my database (oracle);

This stored procedure will set some oracle's session variables, whose will be used at my oracle's view's layer;
so I need to pass some parameter into it, too;

Until this stored procedure is executed , my views wont return any row !

It is possible to execute a non-returning-row procedure; at the same connection used by Report's / Form's dataSets in fast report c# script? using loads events?

Fowards Thanks

Marcos;

ipong

how do you push data from database to fastreport?

mortega

ipong wrote: »

how do you push data from database to fastreport?

Hi;

my sql's are always like

Select *
from someView



I would like to use FastReport embedded connection and FastReport Queries;

As much as fastReport inheritances capabilites

ipong

there are two queries, one for report and one for authentication, if authenticated, you can pass parameter to fastreport

mortega

Maybe I missunderstood or I'm not making myself clear;

Procedure that must be executed before returning any rows from database view layer;
this procedure does not return any row it is just for setting oracle session variables;

So, I must to be sure that all times FastReport connect it execute my "set_active_user";


begin
app_core.set_active_user('DomainName\Username'); <<-- parameter here
end;



Passing parameters it's ok, I almost do it;
By the way, I can use


System.Environment.UserDomainName ;
System.Environment.UserName



Sql Queries are all against my database view's always ( select * from someView );