You are here: Re: Output stored procedure « MsSQL Server « IT news, forums, messages
Re: Output stored procedure

Posted by Erland Sommarskog on 10/02/96 11:48

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/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация