Views and stored procedures

rbuser

Hello,

is it possible to use views and stored procedures when creating reports that
are stored in the database, not the executable.
The problem is that we need to send a parameter to these views or stored
procedures, we have tried with assigning a variable to the parameter, but I
don't know how we can set this from within the program

example:

stored procedure tc_grootb with the parameter 4, how can we call this?

We use Asta and SQL Server.
Thanks,
Bernaert Dominique.

digitalmetaphors

You can write any SQL that you want into a DADE dataview (SQL tab). The only
thing is, the only way RB validates it is by submitting it to the server.
The query tools become disabled once you save edited SQL text.

You can programatically set the SQL text by extracting the TdaSQL object
from the dataview. There is an article in the DADE thread of the TechTips
newsgroup. Set the TdaSQL.SQLText TStrings property.


Cheers,

Jim Bennett
Digital Metaphors