Filips Benoit (benoit.filips@pandora.be) writes:
> How can I show the resultrecords of a SP.
> I can be done by doubleclick the SPname?
> But how to do it by code.
>
> I want the following interface
> In my form the user
> 1 selects a SP (combobox showing a userfrinly name)
> 2 adds the related parameters
> 3 and then click the show result-button
>
> but the .execute command doen't show teh records.

I don't know what .execute you are using, but I would not expect an
..execute method to display any data on its own, but return data in
some data struction that the application would have to deal with.

> I want the same output as you have doublclicking the SPname in the
> objectwindow.

What object window? This is nothing I'm familiar with.

To summarise: you need to provide more details on what you are actually
doing. What sort of environment do you have? What client API etc?


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx