Article View: borland.public.interbase.sql
Article #256Re: @Jan Henrik
From: Jan Henrik Sylvester
Date: Mon, 18 Mar 2002 16:55
Date: Mon, 18 Mar 2002 16:55
19 lines
1757 bytes
1757 bytes
"Helmut W�ss" <h.woess@iis-edv.at> schrieb im Newsbeitrag
news:3c9613ab$1_1@dnews...
> 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?
AFAIK, a procedure only returns a value on SUSPEND.
It has nothing to do with the way you access the return values in your
application.
HTH,
Jan Henrik Sylvester <me@janh.de>
Technical Details
Message-ID:
<3c961bf2_1@dnews>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!supernews.com!peer1-sjc1.usenetserver.com!usenetserver.com!newsfeed1.cidera.com!Cidera!news-hog.berkeley.edu!ucberkeley!nntp-relay.ihug.net!out.nntp.be!propagator-SanJose!in.nntp.be!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnewsReferences:
<3c93cc5f$1_2@dnews> <3c944d23$1_1@dnews> <3c94ceb1_1@dnews> <3c9613ab$1_1@dnews>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII X-Google-Thread: 114a0e,3f0dbf6d00b0f337 X-Google-Attributes: gid114a0e,public X-Google-Thread: fd38c,3f0dbf6d00b0f337 X-Google-Attributes: gidfd38c,public X-Google-ArrivalTime: 2002-03-18 09:06:26 PST User-Agent: Hamster/1.3.23.140 From: "Jan Henrik Sylvester" <me@janh.de> Newsgroups: borland.public.interbase.sql,borland.public.interbase.general References: <3c93cc5f$1_2@dnews> <3c944d23$1_1@dnews> <3c94ceb1_1@dnews> <3c9613ab$1_1@dnews> Subject: Re: @Jan Henrik Date: Mon, 18 Mar 2002 17:55:14 +0100 Lines: 21 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 NNTP-Posting-Host: 172.176.222.167 Message-ID: <3c961bf2_1@dnews> X-Trace: dnews 1016470514 172.176.222.167 (18 Mar 2002 08:55:14 -0800) Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!supernews.com!peer1-sjc1.usenetserver.com!usenetserver.com!newsfeed1.cidera.com!Cidera!news-hog.berkeley.edu!ucberkeley!nntp-relay.ihug.net!out.nntp.be!propagator-SanJose!in.nntp.be!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews