Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Calling stored proc with multiple input rows.

3 posts in AEP Last posting was on 2006-04-28 09:55:20.0Z
Paul Man Posted on 2006-04-27 09:55:56.0Z
From: "Paul Man" <paulman@datasoft.ie>
Newsgroups: Advantage.AEP
Subject: Calling stored proc with multiple input rows.
Date: Thu, 27 Apr 2006 10:55:56 +0100
Lines: 4
Organization: DSoft
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
NNTP-Posting-Host: 82.141.233.142
Message-ID: <4450946e@solutions.advantagedatabase.com>
X-Trace: 27 Apr 2006 03:52:46 -0700, 82.141.233.142
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!82.141.233.142
Xref: solutions.advantagedatabase.com Advantage.AEP:477
Article PK: 1103763

Is it possible to call a stored procedure to have multiple rows in __input.
i.e similar to sending a recordset.


Joachim Duerr (ADS Support) Posted on 2006-04-27 12:32:06.0Z
From: "Joachim Duerr (ADS Support)" <jojo.duerr@gmx.de>
Subject: Re: Calling stored proc with multiple input rows.
Newsgroups: Advantage.AEP
References: <4450946e@solutions.advantagedatabase.com>
Organization: iAnywhere
User-Agent: XanaNews/1.18.1.2
X-Face: ,QMv7[luB)BpWAQ~:"kw6n%0ieY63.:g2K3n~8ky0;||5Xle*Xq+=~<Fy:0CVC2nx@8~vZ
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
NNTP-Posting-Host: 83.236.205.140
Message-ID: <4450abb6@solutions.advantagedatabase.com>
Date: 27 Apr 2006 05:32:06 -0700
X-Trace: 27 Apr 2006 05:32:06 -0700, 83.236.205.140
Lines: 21
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!83.236.205.140
Xref: solutions.advantagedatabase.com Advantage.AEP:478
Article PK: 1103759


Paul Man wrote in <4450946e@solutions.advantagedatabase.com>:

> Is it possible to call a stored procedure to have multiple rows in
> __input. i.e similar to sending a recordset.

no. But you can use a temporary table instead.

--
Joachim Duerr
Senior Product Support Analyst (Advantage Database Server)
iAnywhere Solutions / Extended Systems
advantage[AT]extendsys.de
*********** European Advantage Conference (EAC) 2006 ****************
Do you want to develop faster, deliver better solutions and drive your
business forward?
Plan to attend now THE Advantage event of the Year!
+++ UK - London, 8.-9. May
+++ GERMANY - Frankfurt, 11.-12. May
+++ ITALY - Milano, 15. May
Click for Details: http://www.AdvantageDatabase.com/EAC2006
*********** European Advantage Conference (EAC) 2006 ****************


Paul Man Posted on 2006-04-28 09:55:20.0Z
From: "Paul Man" <paulman@datasoft.ie>
Newsgroups: Advantage.AEP
References: <4450946e@solutions.advantagedatabase.com> <4450abb6@solutions.advantagedatabase.com>
Subject: Re: Calling stored proc with multiple input rows.
Date: Fri, 28 Apr 2006 10:55:20 +0100
Lines: 29
Organization: DSoft
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 82.141.233.142
Message-ID: <4451e5cc@solutions.advantagedatabase.com>
X-Trace: 28 Apr 2006 03:52:12 -0700, 82.141.233.142
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!82.141.233.142
Xref: solutions.advantagedatabase.com Advantage.AEP:479
Article PK: 1103765

Thanks - that's a good idea. I think I'll write a component to support that
a kind of tAdvancedAdsStoredProc that you can accept a datasource or add
input rows.

"Joachim Duerr (ADS Support)" <jojo.duerr@gmx.de> wrote in message
news:4450abb6@solutions.advantagedatabase.com...
> Paul Man wrote in <4450946e@solutions.advantagedatabase.com>:
>
>> Is it possible to call a stored procedure to have multiple rows in
>> __input. i.e similar to sending a recordset.
>
> no. But you can use a temporary table instead.
>
> --
> Joachim Duerr
> Senior Product Support Analyst (Advantage Database Server)
> iAnywhere Solutions / Extended Systems
> advantage[AT]extendsys.de
> *********** European Advantage Conference (EAC) 2006 ****************
> Do you want to develop faster, deliver better solutions and drive your
> business forward?
> Plan to attend now THE Advantage event of the Year!
> +++ UK - London, 8.-9. May
> +++ GERMANY - Frankfurt, 11.-12. May
> +++ ITALY - Milano, 15. May
> Click for Details: http://www.AdvantageDatabase.com/EAC2006
> *********** European Advantage Conference (EAC) 2006 ****************