SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-29-2008, 07:29 PM
| ||||
| ||||
 Output stored procedure 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      |
|
02-29-2008, 07:29 PM
| ||||
| ||||
| Re: Output stored procedure 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 |
Linear Mode
