🚀 go-pugleaf

Hi Jan,

do i really need a suspend in this case ?  I thought it is only necessary
if i have a resultset and use
  myProc.Open;
but here the result comes back in an output parameter, so i use
  myProc.ExecProc;
and get the result with  myProc.ParamByName('aValue).AsInteger;

or am i wrong?

bye,
helmut

"Jan Henrik Sylvester" <me@janh.de> schrieb im Newsbeitrag
news:3c94ceb1_1@dnews...
> "Helmut W�ss" <h.woess@iis-edv.at> schrieb im Newsbeitrag
> news:3c944d23$1_1@dnews...
> > you forgot to put the result into the ouput variable!
> > must be:
> > SELECT count(*) FROM Banners into :a_value;
> >
> > bye,
> > helmut
> >
> > "Ryan Born" <ryanborn@uiuc.edu> schrieb im Newsbeitrag
> > news:3c93cc5f$1_2@dnews...
> > > After an accidental post on my last one, here is my real problem!
> > >
> > > I have this Attempt to create a SP, but it won't work.
> > > ------------------------------------------------------------
> > > SET TERM !!;
> > >
> > > CREATE PROCEDURE my_procedure
> > > RETURNS (a_value INTEGER)
> > > AS
> > > BEGIN
> > >
> > > SELECT count(*) FROM Banners;
> > >
> > > END !!
> > >
> > > SET TERM ;!!
>
> In addition to Helmut W�ss reply, don't forget the "SUSPEND;" if you want
> any return value...
>
> HTH,
> Jan Henrik Sylvester <me@janh.de>
>
>
>