RE: Dealing w/ No Return Result Stored Procedure

use dm.ADOSP_ProjMoveToHistory.ExecProc instead of 
dm.ADOSP_ProjMoveToHistory.open

ExecProc won't expect a result set.

This is from Delphi Help in regards to TSoredProc:

Tip:	If an application is only interested in the result set returned by a 
stored procedure, call StoredProc.Open or set its Active property to True.

I you call open then you must have a result set.

Barry.



On Monday, July 14, 2003 10:22 PM, rizky [SMTP:[email protected]] wrote:
> 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]
>
>
>
>
> 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 ---------------------~-->
Buy Ink Cartridges or Refill Kits for Your HP, Epson, Canon or Lexmark
Printer at Myinks.com. Free s/h on orders $50 or more to the US & Canada.
http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/sOykFB/k9VGAA/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/