RE: Dealing w/ No Return Result Stored Procedure

Im Sorry I Might have Forgot To Tell You About The Database.Im Using Sql
Server 2000 Developer Edition and TAdoStoredProc For The Component
 
dm.ADOSP_ProjMoveToHistory.close;
dm.ADOSP_ProjMoveToHistory.Parameters.ParamByName('@sdate').value :=
formatdatetime('ddmmyyyy', deEOM.date);//Supply Parameter For The Stored
Procedure
dm.ADOSP_ProjMoveToHistory.open  ;
 
On My Stored Procedure Im Using Cursor to Fetch My Data.So if I want to
change using tAdoQuery component can it run this cursor thing..??
 
If it possible I prefer to know how to handle or capture the "command
text doesn't return result set" error rather than to change my technique
coz...you know dateline...dateline...and dateline (Can't live with or
without them).Thank You Guys.
 
Peace \m/
 
 
Richness Is Not Measure By How Much You Have...
But How Less You Need....
 
RichKey

 
-----Original Message-----
From: Barry Pryde [mailto:[email protected]] 
Sent: 15 Juli 2003 20:32
To: '[email protected]'
Subject: RE: [Delphi] Dealing w/ No Return Result Stored Procedure
 
Are you using Query.Active := True?

If so try using Query.ExecSql (Execute does not expect a result set
where Active does.)

On Monday, July 14, 2003 8:11 AM, Daniel Rail [SMTP:[email protected]]
wrote:
> Hi,
> 
> At July 14, 2003, 06:25, rizky wrote:
> 
>  
> > I Have A Problem With My Stored Procedure, Im Using Delphi 5.0, 
> > and I run a stored procedure who doesn't have a return result
> > and I can't get out from "command text doesn't return result set"
error
> > but my query work just fine.
>  
> > How Do I Deal With This Error..???
> 
> First of all,  which RDBMS are you using?  And, which component
> are you trying to use?
> 
> -- 
> Best regards,
>  Daniel Rail
>  Senior System Engineer
>  ACCRA Group Inc. (www.accra.ca)
>  ACCRA Med Software Inc. (www.filopto.com)
> 
> 
> 
> CodeCoffer - new Delphi code protection Tool!
> http://www.delphicollection.com/public/CodeCoffer.htm
> ---------------------------------------------------------------
> Unsubscribe:[email protected]
> List owner:[email protected]
> --------------------------------------------------------------- 
> 
> Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/ 
> 




Yahoo! Groups Sponsor


ADVERTISEMENT
 
<http://rd.yahoo.com/M=194081.3551198.4824677.1261774/D=egroupweb/S=1705
115362:HM/A=1663535/R=0/SIG=11ps6rfef/*http:/www.ediets.com/start.cfm?co
de=30504&media=atkins> click here

 
<http://us.adserver.yahoo.com/l?M=194081.3551198.4824677.1261774/D=egrou
pmail/S=:HM/A=1663535/rand=757384697> 

CodeCoffer - new Delphi code protection Tool!
http://www.delphicollection.com/public/CodeCoffer.htm
---------------------------------------------------------------
Unsubscribe:[email protected]
List owner:[email protected]
--------------------------------------------------------------- 

Your use of Yahoo! Groups is subject to the Yahoo!
<http://docs.yahoo.com/info/terms/>  Terms of Service. 


[Non-text portions of this message have been removed]



------------------------ Yahoo! Groups Sponsor ---------------------~-->
Buy Natural Vitamins for Good Prostate & Male Health. $28.97
http://www.challengerone.com/t/l.asp?cid=2865&lp=prosta2.html
http://us.click.yahoo.com/qJIe0D/89VGAA/ySSFAA/i7folB/TM
---------------------------------------------------------------------~->

CodeCoffer - new Delphi code protection Tool!
http://www.delphicollection.com/public/CodeCoffer.htm
---------------------------------------------------------------
Unsubscribe:[email protected]
List owner:[email protected]
--------------------------------------------------------------- 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/