By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,413 Members | 1,594 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,413 IT Pros & Developers. It's quick & easy.

Output stored procedure

P: n/a
Dear All,

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 want the same output as you have doublclicking the SPname in the
objectwindow.

Thanks,

Filip
May 25 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Filips Benoit (be***********@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, es****@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
May 25 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.