MEGA Search
20.3 Million


Sign Up
From: Greg Rowland  
Subject: Error creating cursor handle
NewsGroup: borland.public.delphi.database.sqlservers
Date Posted: 1-May-2003 at 13:31:59 PST
Delphi 6.0, BDE, SQL 2000

TStoredProcedure returns subject error?


Thanx in advance,

Greg



From: Greg Rowland  
Subject: Re: Error creating cursor handle
NewsGroup: borland.public.delphi.database.sqlservers
Date Posted: 1-May-2003 at 15:58:33 PST
Oops, I did not return the OUTPUT correctly.




From: Greg Rowland  
Subject: Re: Error creating cursor handle
NewsGroup: borland.public.delphi.database.sqlservers
Date Posted: 1-May-2003 at 14:28:6 PST
Hi Bill,

Yes, TStoredProc

Yes, Returns a single result value.

Execute with Open.

Also returns same error in IDE when setting active in the Object Inspector.



"Bill Todd"  wrote in message
news:0ds2bvc7leu4jku346at76p6sv06m4o7j2@4ax.com...
>
>
> On Thu, 1 May 2003 13:31:59 -0500, "Greg Rowland"
>  wrote:
>
> >Delphi 6.0, BDE, SQL 2000
> >
> >TStoredProcedure returns subject error?
>
> There is no such component (at least not supplied by Borland). I
> assume you mean TStoredProc.
>
> Does the stored procedure return a result set?
> Did you execute the procedure by calling Open or by calling ExecProc?
>
>
> --
> Bill (TeamB)
> (TeamB cannot respond to questions received via email)



From: Bill Todd  
Subject: Re: Error creating cursor handle
NewsGroup: borland.public.delphi.database.sqlservers
Date Posted: 1-May-2003 at 12:13:50 PST

On Thu, 1 May 2003 13:31:59 -0500, "Greg Rowland"
 wrote:

>Delphi 6.0, BDE, SQL 2000
>
>TStoredProcedure returns subject error?

There is no such component (at least not supplied by Borland). I
assume you mean TStoredProc.

Does the stored procedure return a result set?
Did you execute the procedure by calling Open or by calling ExecProc?


--
Bill (TeamB)
(TeamB cannot respond to questions received via email)