Re: Using a Storedprocedure as a View

Hello,
That would say, that I have to add new objects to the program that I am
writing.
For each View a new ADO table and a new Source.
I develope an application with Delphi 7 and want to use the
ADOStoredProcedure the same
way as I do with querys etc.
I want to put as much logic as possible into the Database.

Is it even possible to work with procedures this way? Can a procedure return
the Values that I need, a kind of Table?
thx,
   Alexander

>Why not just create another view, which is a view of the view?  I have
>highly nested views on my databases.
>
>Jon
>
>On Tue, 9 Mar 2004, Alexander Hachmann wrote:

>> Hello,
>> I know that this was discussed many times, but all the answers did not
help
>> me yet.
>> I need to create a Procedure that returns the same data as a view does
>> except, that the the
>> data was filtered by a parameter.
>> I want to execute a procedure with a parameter and get back a 'view'.
>> I only made prcedures giving back simple values. Can they give back data
as
>> Views does.
>> I dont want the procedure to create a view on which i have to query again
>> because the query the Procedure does
>> can go over more stages than just this one. The procedure calls another
>> procedure and handles this as a subselect.
>> Can any one help me?
>> Thx,
>>    Alexander
>>
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 8: explain analyze is your friend
>>