BorlandTalk.com Forum Index BorlandTalk.com
Borland discussion newsgroups
 
Archives   FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Stored Procedure in D2005

 
Post new topic   Reply to topic    BorlandTalk.com Forum Index -> Delphi Databases (SQL Servers)
View previous topic :: View next topic  
Author Message
Sumathi
Guest
PostPosted: Tue Feb 14, 2006 6:03 am    Post subject: Stored Procedure in D2005 Reply with quote


Hi All,

I have written a stored procedure in MS SQL Enterprise Manager v8.0. It's a
select query to return a result set. I am trying to access this stored
procedure through D2005 web service, BDPConnection object and BDPCommand are
used in this module.

During the design time I can execute the stored procedure via 'Stored
Procedure Dialog' and by checking the 'Stored Procedure has one or more
resultset' checkbox. But it does not return any result during the runtime.
How to set the value of 'Stored Procedure has one or more resultset'
checkbox at runtime? Please help.

Thanks,
Sumathi.
Back to top
helmut woess
Guest
PostPosted: Tue Feb 14, 2006 9:03 am    Post subject: Re: Stored Procedure in D2005 Reply with quote


Am Tue, 14 Feb 2006 10:45:03 +0530 schrieb Sumathi:

Quote:
Hi All,

I have written a stored procedure in MS SQL Enterprise Manager v8.0. It's a
select query to return a result set. I am trying to access this stored
procedure through D2005 web service, BDPConnection object and BDPCommand are
used in this module.

During the design time I can execute the stored procedure via 'Stored
Procedure Dialog' and by checking the 'Stored Procedure has one or more
resultset' checkbox. But it does not return any result during the runtime.
How to set the value of 'Stored Procedure has one or more resultset'
checkbox at runtime? Please help.

Thanks,
Sumathi.

Hmm, i don't know exactly what you mean with "during the runtime". But put
a "SET NOCOUNT ON" as first line in your stored proc, then you should get a
result set back.

bye, Helmut
Back to top
Sumathi
Guest
PostPosted: Wed Feb 15, 2006 7:03 am    Post subject: Re: Stored Procedure in D2005 Reply with quote


Hi,

There was some problem with the way I set the parameter for BDPCommand
component in D2005. Once I fix that, I got it working.

Thanks for your response.

Sumathi.

"helmut woess" <hw (AT) iis (DOT) at> wrote in message
news:8guz3k25ua0m.1m1a7g0e05ya5.dlg (AT) 40tude (DOT) net...
Quote:
Am Tue, 14 Feb 2006 10:45:03 +0530 schrieb Sumathi:

Hi All,

I have written a stored procedure in MS SQL Enterprise Manager v8.0.
It's a
select query to return a result set. I am trying to access this stored
procedure through D2005 web service, BDPConnection object and BDPCommand
are
used in this module.

During the design time I can execute the stored procedure via 'Stored
Procedure Dialog' and by checking the 'Stored Procedure has one or more
resultset' checkbox. But it does not return any result during the
runtime.
How to set the value of 'Stored Procedure has one or more resultset'
checkbox at runtime? Please help.

Thanks,
Sumathi.

Hmm, i don't know exactly what you mean with "during the runtime". But put
a "SET NOCOUNT ON" as first line in your stored proc, then you should get
a
result set back.

bye, Helmut
Back to top
Display posts from previous:   
Post new topic   Reply to topic    BorlandTalk.com Forum Index -> Delphi Databases (SQL Servers) All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2006 phpBB Group
SEO toolkit © 2004-2006 webmedic.