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.

Getting OUT parameters

2 posts in QAnywhere Last posting was on 2005-09-12 16:05:26.0Z
Kornilov Alexey Posted on 2005-09-12 15:29:43.0Z
From: "Kornilov Alexey" <alekcey@ukr.net>
Newsgroups: ianywhere.public.sqlanywhere.qanywhere
Subject: Getting OUT parameters
Lines: 16
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
X-Original-NNTP-Posting-Host: dp-142.paco.net
Message-ID: <43259199@forums-2-dub>
X-Original-Trace: 12 Sep 2005 07:32:57 -0700, dp-142.paco.net
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 12 Sep 2005 07:32:58 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 12 Sep 2005 08:29:43 -0700
X-Trace: forums-1-dub 1126538983 10.22.108.75 (12 Sep 2005 08:29:43 -0700)
X-Original-Trace: 12 Sep 2005 08:29:43 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.sqlanywhere.qanywhere:139
Article PK: 10452

Hi!
I writing small test application on VC7.1 which must execute via ADO (v.2.8)
a stored procedure (ASA 9.02 Win32).
Test SP:
ALTER PROCEDURE "DBA"."test_ado_proc1"( INOUT @p_out int)
BEGIN
set @p_out=10;
select 'test1'
END
I have problem getting OUT parameter value. My C++ code work fine if SP
return only result set or return only out parameters.
Is anybody have C++ example for this task?

Thank's.


Chris Keating (iAnywhere Solutions) Posted on 2005-09-12 16:05:26.0Z
From: "Chris Keating \(iAnywhere Solutions\)" <Spam_NoThanks_keating@iAnywhere.com>
Newsgroups: ianywhere.public.sqlanywhere.qanywhere
References: <43259199@forums-2-dub>
Subject: Re: Getting OUT parameters
Lines: 23
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Response
X-Original-NNTP-Posting-Host: keating-xp2.sybase.com
Message-ID: <4325a736@forums-2-dub>
X-Original-Trace: 12 Sep 2005 09:05:10 -0700, keating-xp2.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 12 Sep 2005 09:05:11 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 12 Sep 2005 09:05:26 -0700
X-Trace: forums-1-dub 1126541126 10.22.108.75 (12 Sep 2005 09:05:26 -0700)
X-Original-Trace: 12 Sep 2005 09:05:26 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.sqlanywhere.qanywhere:140
Article PK: 18767

You may want to post this to sybase.public.sqlanywhere.general. This group
addresses questions related to qAnywhere.

"Kornilov Alexey" <alekcey@ukr.net> wrote in message
news:43259199@forums-2-dub...
> Hi!
> I writing small test application on VC7.1 which must execute via ADO
> (v.2.8) a stored procedure (ASA 9.02 Win32).
> Test SP:
> ALTER PROCEDURE "DBA"."test_ado_proc1"( INOUT @p_out int)
> BEGIN
> set @p_out=10;
> select 'test1'
> END
> I have problem getting OUT parameter value. My C++ code work fine if SP
> return only result set or return only out parameters.
> Is anybody have C++ example for this task?
>
> Thank's.
>