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.

How can we access result set from select statement in Stored Procedure

7 posts in General Discussion Last posting was on 2004-02-26 17:01:24.0Z
Chandresh Patel Posted on 2004-02-25 23:57:46.0Z
From: "Chandresh Patel" <bapashree@yahoo.com>
Newsgroups: ianywhere.public.general
Subject: How can we access result set from select statement in Stored Procedure
Lines: 19
Organization: Shreeji Smart Solution
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
X-Original-NNTP-Posting-Host: ac93c88f.ipt.aol.com
Message-ID: <403d368c@forums-2-dub>
X-Original-Trace: 25 Feb 2004 15:58:04 -0800, ac93c88f.ipt.aol.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 25 Feb 2004 15:57:06 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 25 Feb 2004 15:57:46 -0800
X-Trace: forums-1-dub 1077753466 10.22.108.75 (25 Feb 2004 15:57:46 -0800)
X-Original-Trace: 25 Feb 2004 15:57:46 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2638
Article PK: 6110

Sybase Anywhere 9.0.0.1108

In C# .net for get select statement date, we use ASADataReader. but how
about in Stored Procedure.

ASADataReader = cmd.ExecuteReader;

In Stored Procedure

BEGIN

SELECT nID, sName FROM MyStore;
//Here how can i stored this select statement result.

END

Thanks in Advance.


Chris Keating (iAnywhere Solutions) Posted on 2004-02-26 01:04:27.0Z
From: "Chris Keating \(iAnywhere Solutions\)" <FightSpam_keating@iAnywhere.com>
Newsgroups: ianywhere.public.general
References: <403d368c@forums-2-dub>
Subject: Re: How can we access result set from select statement in Stored Procedure
Lines: 67
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: vpn-concord-060.sybase.com
X-Original-NNTP-Posting-Host: vpn-concord-060.sybase.com
Message-ID: <403d461b$1@forums-1-dub>
Date: 25 Feb 2004 17:04:27 -0800
X-Trace: forums-1-dub 1077757467 158.159.8.60 (25 Feb 2004 17:04:27 -0800)
X-Original-Trace: 25 Feb 2004 17:04:27 -0800, vpn-concord-060.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2640
Article PK: 6114

You have asked this question already. Please see your post dated Feb 17,
2004 in the sybase.public.sqlanywhere.mobilink group in which I directed you
to the documentation that covers this topic.

BTW
Asking the same question multiple times creates unnecessary work for those
who are volunteering their time in the newsgroup. Fruthermore, people may be
unwilling to assist if it is believed that the questions are being
duplicated.

If you need clarification, please indicate what you have tried and the
problems that you are having. Please include the code, error messages, and
other relevant information. I would also recommend that the documentation
answers many of the question that you have. You can save time (and learn
more) by researching the documentation first.


--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

****************************************************************************
*
Sign up today for your copy of the SQL Anywhere Studio 9 Developer Edition
and try out the market-leading database for mobile, embedded and small to
medium sized business environments for free!

http://www.ianywhere.com/promos/deved/index.html

****************************************************************************
*

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use CaseXpress to report bugs http://casexpress.sybase.com

****************************************************************************
*

"Chandresh Patel" <bapashree@yahoo.com> wrote in message
news:403d368c@forums-2-dub...
> Sybase Anywhere 9.0.0.1108
>
> In C# .net for get select statement date, we use ASADataReader. but how
> about in Stored Procedure.
>
> ASADataReader = cmd.ExecuteReader;
>
> In Stored Procedure
>
> BEGIN
>
> SELECT nID, sName FROM MyStore;
> //Here how can i stored this select statement result.
>
> END
>
> Thanks in Advance.
>
>


Chandresh Patel Posted on 2004-02-26 04:21:29.0Z
From: "Chandresh Patel" <bapashree@yahoo.com>
Newsgroups: ianywhere.public.general
References: <403d368c@forums-2-dub> <403d461b$1@forums-1-dub>
Subject: Re: How can we access result set from select statement in Stored Procedure
Lines: 98
Organization: Shreeji Smart Solution
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: ac945acf.ipt.aol.com
X-Original-NNTP-Posting-Host: ac945acf.ipt.aol.com
Message-ID: <403d7449@forums-1-dub>
Date: 25 Feb 2004 20:21:29 -0800
X-Trace: forums-1-dub 1077769289 172.148.90.207 (25 Feb 2004 20:21:29 -0800)
X-Original-Trace: 25 Feb 2004 20:21:29 -0800, ac945acf.ipt.aol.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2643
Article PK: 6115

Chris,

I am not asking you same question (in mobilink i asked for create procedure
and get result set in c#) But here my question is diffrent.

I want to access that result in same Stored Procedure not out side of the
procedure. and thats why i put this example.


How do i go through this all fetch record in In Stored Procedure. What I
have to write ( not in C# application but in procedure)

I put question mark for that

BEGIN

? = SELECT nID, sName FROM MyStore;
//Here how can i stored this select statement result.

END


"Chris Keating (iAnywhere Solutions)" <FightSpam_keating@iAnywhere.com>

wrote in message news:403d461b$1@forums-1-dub...
> You have asked this question already. Please see your post dated Feb 17,
> 2004 in the sybase.public.sqlanywhere.mobilink group in which I directed
you
> to the documentation that covers this topic.
>
> BTW
> Asking the same question multiple times creates unnecessary work for those
> who are volunteering their time in the newsgroup. Fruthermore, people may
be
> unwilling to assist if it is believed that the questions are being
> duplicated.
>
> If you need clarification, please indicate what you have tried and the
> problems that you are having. Please include the code, error messages, and
> other relevant information. I would also recommend that the documentation
> answers many of the question that you have. You can save time (and learn
> more) by researching the documentation first.
>
>
> --
>
> Chris Keating
> Sybase Adaptive Server Anywhere Professional Version 8
>
>
****************************************************************************
> *
> Sign up today for your copy of the SQL Anywhere Studio 9 Developer Edition
> and try out the market-leading database for mobile, embedded and small to
> medium sized business environments for free!
>
> http://www.ianywhere.com/promos/deved/index.html
>
>
****************************************************************************
> *
>
> iAnywhere Solutions http://www.iAnywhere.com
>
> ** Please only post to the newsgroup
>
> ** Whitepapers can be found at http://www.iAnywhere.com/developer
> ** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
> ** Use CaseXpress to report bugs http://casexpress.sybase.com
>
>
****************************************************************************
> *
>
> "Chandresh Patel" <bapashree@yahoo.com> wrote in message
> news:403d368c@forums-2-dub...
> > Sybase Anywhere 9.0.0.1108
> >
> > In C# .net for get select statement date, we use ASADataReader. but how
> > about in Stored Procedure.
> >
> > ASADataReader = cmd.ExecuteReader;
> >
> > In Stored Procedure
> >
> > BEGIN
> >
> > SELECT nID, sName FROM MyStore;
> > //Here how can i stored this select statement result.
> >
> > END
> >
> > Thanks in Advance.
> >
> >
>
>


Chris Keating (iAnywhere Solutions) Posted on 2004-02-26 04:54:07.0Z
From: "Chris Keating \(iAnywhere Solutions\)" <FightSpam_keating@iAnywhere.com>
Newsgroups: ianywhere.public.general
References: <403d368c@forums-2-dub> <403d461b$1@forums-1-dub> <403d7449@forums-1-dub>
Subject: Re: How can we access result set from select statement in Stored Procedure
Lines: 150
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: vpn-concord-060.sybase.com
X-Original-NNTP-Posting-Host: vpn-concord-060.sybase.com
Message-ID: <403d7bef@forums-1-dub>
Date: 25 Feb 2004 20:54:07 -0800
X-Trace: forums-1-dub 1077771247 158.159.8.60 (25 Feb 2004 20:54:07 -0800)
X-Original-Trace: 25 Feb 2004 20:54:07 -0800, vpn-concord-060.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2645
Article PK: 6118

You question was somewhat confusing in that you started with a reference to
C# and working with procs. Best not to include information that can add
confusion to the question or is not relevant.

What specifically do you want to do with the resultset of the inlined
procedure? I suspect that you may want a cursor but....




--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

****************************************************************************
*
Sign up today for your copy of the SQL Anywhere Studio 9 Developer Edition
and try out the market-leading database for mobile, embedded and small to
medium sized business environments for free!

http://www.ianywhere.com/promos/deved/index.html

****************************************************************************
*

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use CaseXpress to report bugs http://casexpress.sybase.com

****************************************************************************
*

"Chandresh Patel" <bapashree@yahoo.com> wrote in message
news:403d7449@forums-1-dub...
> Chris,
>
> I am not asking you same question (in mobilink i asked for create
procedure
> and get result set in c#) But here my question is diffrent.
>
> I want to access that result in same Stored Procedure not out side of the
> procedure. and thats why i put this example.
>
>
> How do i go through this all fetch record in In Stored Procedure. What I
> have to write ( not in C# application but in procedure)
>
> I put question mark for that
>
> BEGIN
>
> ? = SELECT nID, sName FROM MyStore;
> //Here how can i stored this select statement result.
>
> END
>
>
> "Chris Keating (iAnywhere Solutions)" <FightSpam_keating@iAnywhere.com>
> wrote in message news:403d461b$1@forums-1-dub...
> > You have asked this question already. Please see your post dated Feb 17,
> > 2004 in the sybase.public.sqlanywhere.mobilink group in which I directed
> you
> > to the documentation that covers this topic.
> >
> > BTW
> > Asking the same question multiple times creates unnecessary work for
those
> > who are volunteering their time in the newsgroup. Fruthermore, people
may
> be
> > unwilling to assist if it is believed that the questions are being
> > duplicated.
> >
> > If you need clarification, please indicate what you have tried and the
> > problems that you are having. Please include the code, error messages,
and
> > other relevant information. I would also recommend that the
documentation
> > answers many of the question that you have. You can save time (and learn
> > more) by researching the documentation first.
> >
> >
> > --
> >
> > Chris Keating
> > Sybase Adaptive Server Anywhere Professional Version 8
> >
> >
>
****************************************************************************
> > *
> > Sign up today for your copy of the SQL Anywhere Studio 9 Developer
Edition
> > and try out the market-leading database for mobile, embedded and small
to
> > medium sized business environments for free!
> >
> > http://www.ianywhere.com/promos/deved/index.html
> >
> >
>
****************************************************************************
> > *
> >
> > iAnywhere Solutions http://www.iAnywhere.com
> >
> > ** Please only post to the newsgroup
> >
> > ** Whitepapers can be found at http://www.iAnywhere.com/developer
> > ** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
> > ** Use CaseXpress to report bugs http://casexpress.sybase.com
> >
> >
>
****************************************************************************
> > *
> >
> > "Chandresh Patel" <bapashree@yahoo.com> wrote in message
> > news:403d368c@forums-2-dub...
> > > Sybase Anywhere 9.0.0.1108
> > >
> > > In C# .net for get select statement date, we use ASADataReader. but
how
> > > about in Stored Procedure.
> > >
> > > ASADataReader = cmd.ExecuteReader;
> > >
> > > In Stored Procedure
> > >
> > > BEGIN
> > >
> > > SELECT nID, sName FROM MyStore;
> > > //Here how can i stored this select statement result.
> > >
> > > END
> > >
> > > Thanks in Advance.
> > >
> > >
> >
> >
>
>


Robert Waywell Posted on 2004-02-26 15:24:04.0Z
From: "Robert Waywell" <nospam_rwaywell@ianywhere.com>
Newsgroups: ianywhere.public.general
References: <403d368c@forums-2-dub> <403d461b$1@forums-1-dub> <403d7449@forums-1-dub>
Subject: Re: How can we access result set from select statement in Stored Procedure
Lines: 216
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
X-Original-NNTP-Posting-Host: rwaywell-pc.sybase.com
Message-ID: <403e0fa7$1@forums-2-dub>
X-Original-Trace: 26 Feb 2004 07:24:23 -0800, rwaywell-pc.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 26 Feb 2004 07:23:20 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 26 Feb 2004 07:24:04 -0800
X-Trace: forums-1-dub 1077809044 10.22.108.75 (26 Feb 2004 07:24:04 -0800)
X-Original-Trace: 26 Feb 2004 07:24:04 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2656
Article PK: 6128

Hi Chandresh,
You might be interested in one of our training courses such as:




Adaptive Server Anywhere 9.0 Fundamentals
Managing your Mobile and Workgroup Data




http://www.sybase.com/detail?id=1024981

Should you be interested in a customized, on-site delivery, then we can
include not just the Programming Interfaces Overview module, but also a
detailed module on using the .NET provider.

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports:
http://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=B
ug

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer

"Chandresh Patel" <bapashree@yahoo.com> wrote in message
news:403d7449@forums-1-dub...
> Chris,
>
> I am not asking you same question (in mobilink i asked for create
procedure
> and get result set in c#) But here my question is diffrent.
>
> I want to access that result in same Stored Procedure not out side of the
> procedure. and thats why i put this example.
>
>
> How do i go through this all fetch record in In Stored Procedure. What I
> have to write ( not in C# application but in procedure)
>
> I put question mark for that
>
> BEGIN
>
> ? = SELECT nID, sName FROM MyStore;
> //Here how can i stored this select statement result.
>
> END
>
>
> "Chris Keating (iAnywhere Solutions)" <FightSpam_keating@iAnywhere.com>
> wrote in message news:403d461b$1@forums-1-dub...
> > You have asked this question already. Please see your post dated Feb 17,
> > 2004 in the sybase.public.sqlanywhere.mobilink group in which I directed
> you
> > to the documentation that covers this topic.
> >
> > BTW
> > Asking the same question multiple times creates unnecessary work for
those
> > who are volunteering their time in the newsgroup. Fruthermore, people
may
> be
> > unwilling to assist if it is believed that the questions are being
> > duplicated.
> >
> > If you need clarification, please indicate what you have tried and the
> > problems that you are having. Please include the code, error messages,
and
> > other relevant information. I would also recommend that the
documentation
> > answers many of the question that you have. You can save time (and learn
> > more) by researching the documentation first.
> >
> >
> > --
> >
> > Chris Keating
> > Sybase Adaptive Server Anywhere Professional Version 8
> >
> >
>
****************************************************************************
> > *
> > Sign up today for your copy of the SQL Anywhere Studio 9 Developer
Edition
> > and try out the market-leading database for mobile, embedded and small
to
> > medium sized business environments for free!
> >
> > http://www.ianywhere.com/promos/deved/index.html
> >
> >
>
****************************************************************************
> > *
> >
> > iAnywhere Solutions http://www.iAnywhere.com
> >
> > ** Please only post to the newsgroup
> >
> > ** Whitepapers can be found at http://www.iAnywhere.com/developer
> > ** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
> > ** Use CaseXpress to report bugs http://casexpress.sybase.com
> >
> >
>
****************************************************************************
> > *
> >
> > "Chandresh Patel" <bapashree@yahoo.com> wrote in message
> > news:403d368c@forums-2-dub...
> > > Sybase Anywhere 9.0.0.1108
> > >
> > > In C# .net for get select statement date, we use ASADataReader. but
how
> > > about in Stored Procedure.
> > >
> > > ASADataReader = cmd.ExecuteReader;
> > >
> > > In Stored Procedure
> > >
> > > BEGIN
> > >
> > > SELECT nID, sName FROM MyStore;
> > > //Here how can i stored this select statement result.
> > >
> > > END
> > >
> > > Thanks in Advance.
> > >
> > >
> >
> >
>
>

aquisitionweb.gif

Chandresh Patel Posted on 2004-02-26 16:36:56.0Z
From: "Chandresh Patel" <bapashree@yahoo.com>
Newsgroups: ianywhere.public.general
References: <403d368c@forums-2-dub> <403d461b$1@forums-1-dub> <403d7449@forums-1-dub> <403e0fa7$1@forums-2-dub>
Subject: Re: How can we access result set from select statement in Stored Procedure
Lines: 182
Organization: Shreeji Smart Solution
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
X-Original-NNTP-Posting-Host: ac9f7a0f.ipt.aol.com
Message-ID: <403e20ba@forums-2-dub>
X-Original-Trace: 26 Feb 2004 08:37:14 -0800, ac9f7a0f.ipt.aol.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 26 Feb 2004 08:36:12 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 26 Feb 2004 08:36:56 -0800
X-Trace: forums-1-dub 1077813416 10.22.108.75 (26 Feb 2004 08:36:56 -0800)
X-Original-Trace: 26 Feb 2004 08:36:56 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2657
Article PK: 6130

You are right,

But when i do some select statement in procedure and i want to get
information on that result and run another query based on previous query
data.

Your attachment not open here.

Thanks in Advance.

"Robert Waywell" <nospam_rwaywell@ianywhere.com> wrote in message
news:403e0fa7$1@forums-2-dub...
> Hi Chandresh,
> You might be interested in one of our training courses such as:
>
>
>
>
> Adaptive Server Anywhere 9.0 Fundamentals
> Managing your Mobile and Workgroup Data
>
>
>
>
> http://www.sybase.com/detail?id=1024981
>
> Should you be interested in a customized, on-site delivery, then we
can
> include not just the Programming Interfaces Overview module, but also a
> detailed module on using the .NET provider.
>
> --
> -----------------------------------------------
> Robert Waywell
> Sybase Adaptive Server Anywhere Developer - Version 8
> Sybase Certified Professional
>
> Sybase's iAnywhere Solutions
>
> Please respond ONLY to newsgroup
>
> EBF's and Patches: http://downloads.sybase.com
> choose SQL Anywhere Studio >> change 'time frame' to all
>
> To Submit Bug Reports:
>
http://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=B
> ug
>
> SQL Anywhere Studio Supported Platforms and Support Status
> http://my.sybase.com/detail?id=1002288
>
> Whitepapers, TechDocs, and bug fixes are all available through the
iAnywhere
> Developer Community at www.ianywhere.com/developer
>
> "Chandresh Patel" <bapashree@yahoo.com> wrote in message
> news:403d7449@forums-1-dub...
> > Chris,
> >
> > I am not asking you same question (in mobilink i asked for create
> procedure
> > and get result set in c#) But here my question is diffrent.
> >
> > I want to access that result in same Stored Procedure not out side of
the
> > procedure. and thats why i put this example.
> >
> >
> > How do i go through this all fetch record in In Stored Procedure. What I
> > have to write ( not in C# application but in procedure)
> >
> > I put question mark for that
> >
> > BEGIN
> >
> > ? = SELECT nID, sName FROM MyStore;
> > //Here how can i stored this select statement result.
> >
> > END
> >
> >
> > "Chris Keating (iAnywhere Solutions)" <FightSpam_keating@iAnywhere.com>
> > wrote in message news:403d461b$1@forums-1-dub...
> > > You have asked this question already. Please see your post dated Feb
17,
> > > 2004 in the sybase.public.sqlanywhere.mobilink group in which I
directed
> > you
> > > to the documentation that covers this topic.
> > >
> > > BTW
> > > Asking the same question multiple times creates unnecessary work for
> those
> > > who are volunteering their time in the newsgroup. Fruthermore, people
> may
> > be
> > > unwilling to assist if it is believed that the questions are being
> > > duplicated.
> > >
> > > If you need clarification, please indicate what you have tried and the
> > > problems that you are having. Please include the code, error messages,
> and
> > > other relevant information. I would also recommend that the
> documentation
> > > answers many of the question that you have. You can save time (and
learn
> > > more) by researching the documentation first.
> > >
> > >
> > > --
> > >
> > > Chris Keating
> > > Sybase Adaptive Server Anywhere Professional Version 8
> > >
> > >
> >
>
****************************************************************************
> > > *
> > > Sign up today for your copy of the SQL Anywhere Studio 9 Developer
> Edition
> > > and try out the market-leading database for mobile, embedded and small
> to
> > > medium sized business environments for free!
> > >
> > > http://www.ianywhere.com/promos/deved/index.html
> > >
> > >
> >
>
****************************************************************************
> > > *
> > >
> > > iAnywhere Solutions http://www.iAnywhere.com
> > >
> > > ** Please only post to the newsgroup
> > >
> > > ** Whitepapers can be found at http://www.iAnywhere.com/developer
> > > ** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
> > > ** Use CaseXpress to report bugs http://casexpress.sybase.com
> > >
> > >
> >
>
****************************************************************************
> > > *
> > >
> > > "Chandresh Patel" <bapashree@yahoo.com> wrote in message
> > > news:403d368c@forums-2-dub...
> > > > Sybase Anywhere 9.0.0.1108
> > > >
> > > > In C# .net for get select statement date, we use ASADataReader. but
> how
> > > > about in Stored Procedure.
> > > >
> > > > ASADataReader = cmd.ExecuteReader;
> > > >
> > > > In Stored Procedure
> > > >
> > > > BEGIN
> > > >
> > > > SELECT nID, sName FROM MyStore;
> > > > //Here how can i stored this select statement result.
> > > >
> > > > END
> > > >
> > > > Thanks in Advance.
> > > >
> > > >
> > >
> > >
> >
> >
>
>
>


Reg Domaratzki Posted on 2004-02-26 17:01:24.0Z
From: "Reg Domaratzki" <Spam_bad_rdomarat@ianywhere.com>
Newsgroups: ianywhere.public.general
References: <403d368c@forums-2-dub> <403d461b$1@forums-1-dub> <403d7449@forums-1-dub> <403e0fa7$1@forums-2-dub> <403e20ba@forums-2-dub>
Subject: Re: How can we access result set from select statement in Stored Procedure
Lines: 214
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: rdomarat-pc.sybase.com
X-Original-NNTP-Posting-Host: rdomarat-pc.sybase.com
Message-ID: <403e2664$1@forums-1-dub>
Date: 26 Feb 2004 09:01:24 -0800
X-Trace: forums-1-dub 1077814884 172.31.143.163 (26 Feb 2004 09:01:24 -0800)
X-Original-Trace: 26 Feb 2004 09:01:24 -0800, rdomarat-pc.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2658
Article PK: 6131

See the docs are learn about how to use cursors.

ASA Programming Guide
Using SQL in Applications
Introduction to cursors
Working with cursors

--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup

iAnywhere Developer Community : http://www.ianywhere.com/developer
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL

"Chandresh Patel" <bapashree@yahoo.com> wrote in message
news:403e20ba@forums-2-dub...
> You are right,
>
> But when i do some select statement in procedure and i want to get
> information on that result and run another query based on previous query
> data.
>
> Your attachment not open here.
>
> Thanks in Advance.
>
>
>
>
> "Robert Waywell" <nospam_rwaywell@ianywhere.com> wrote in message
> news:403e0fa7$1@forums-2-dub...
> > Hi Chandresh,
> > You might be interested in one of our training courses such as:
> >
> >
> >
> >
> > Adaptive Server Anywhere 9.0 Fundamentals
> > Managing your Mobile and Workgroup Data
> >
> >
> >
> >
> > http://www.sybase.com/detail?id=1024981
> >
> > Should you be interested in a customized, on-site delivery, then we
> can
> > include not just the Programming Interfaces Overview module, but also a
> > detailed module on using the .NET provider.
> >
> > --
> > -----------------------------------------------
> > Robert Waywell
> > Sybase Adaptive Server Anywhere Developer - Version 8
> > Sybase Certified Professional
> >
> > Sybase's iAnywhere Solutions
> >
> > Please respond ONLY to newsgroup
> >
> > EBF's and Patches: http://downloads.sybase.com
> > choose SQL Anywhere Studio >> change 'time frame' to all
> >
> > To Submit Bug Reports:
> >
>
http://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=B
> > ug
> >
> > SQL Anywhere Studio Supported Platforms and Support Status
> > http://my.sybase.com/detail?id=1002288
> >
> > Whitepapers, TechDocs, and bug fixes are all available through the
> iAnywhere
> > Developer Community at www.ianywhere.com/developer
> >
> > "Chandresh Patel" <bapashree@yahoo.com> wrote in message
> > news:403d7449@forums-1-dub...
> > > Chris,
> > >
> > > I am not asking you same question (in mobilink i asked for create
> > procedure
> > > and get result set in c#) But here my question is diffrent.
> > >
> > > I want to access that result in same Stored Procedure not out side of
> the
> > > procedure. and thats why i put this example.
> > >
> > >
> > > How do i go through this all fetch record in In Stored Procedure. What
I
> > > have to write ( not in C# application but in procedure)
> > >
> > > I put question mark for that
> > >
> > > BEGIN
> > >
> > > ? = SELECT nID, sName FROM MyStore;
> > > //Here how can i stored this select statement result.
> > >
> > > END
> > >
> > >
> > > "Chris Keating (iAnywhere Solutions)"
<FightSpam_keating@iAnywhere.com>
> > > wrote in message news:403d461b$1@forums-1-dub...
> > > > You have asked this question already. Please see your post dated Feb
> 17,
> > > > 2004 in the sybase.public.sqlanywhere.mobilink group in which I
> directed
> > > you
> > > > to the documentation that covers this topic.
> > > >
> > > > BTW
> > > > Asking the same question multiple times creates unnecessary work for
> > those
> > > > who are volunteering their time in the newsgroup. Fruthermore,
people
> > may
> > > be
> > > > unwilling to assist if it is believed that the questions are being
> > > > duplicated.
> > > >
> > > > If you need clarification, please indicate what you have tried and
the
> > > > problems that you are having. Please include the code, error
messages,
> > and
> > > > other relevant information. I would also recommend that the
> > documentation
> > > > answers many of the question that you have. You can save time (and
> learn
> > > > more) by researching the documentation first.
> > > >
> > > >
> > > > --
> > > >
> > > > Chris Keating
> > > > Sybase Adaptive Server Anywhere Professional Version 8
> > > >
> > > >
> > >
> >
>
****************************************************************************
> > > > *
> > > > Sign up today for your copy of the SQL Anywhere Studio 9 Developer
> > Edition
> > > > and try out the market-leading database for mobile, embedded and
small
> > to
> > > > medium sized business environments for free!
> > > >
> > > > http://www.ianywhere.com/promos/deved/index.html
> > > >
> > > >
> > >
> >
>
****************************************************************************
> > > > *
> > > >
> > > > iAnywhere Solutions http://www.iAnywhere.com
> > > >
> > > > ** Please only post to the newsgroup
> > > >
> > > > ** Whitepapers can be found at http://www.iAnywhere.com/developer
> > > > ** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
> > > > ** Use CaseXpress to report bugs http://casexpress.sybase.com
> > > >
> > > >
> > >
> >
>
****************************************************************************
> > > > *
> > > >
> > > > "Chandresh Patel" <bapashree@yahoo.com> wrote in message
> > > > news:403d368c@forums-2-dub...
> > > > > Sybase Anywhere 9.0.0.1108
> > > > >
> > > > > In C# .net for get select statement date, we use ASADataReader.
but
> > how
> > > > > about in Stored Procedure.
> > > > >
> > > > > ASADataReader = cmd.ExecuteReader;
> > > > >
> > > > > In Stored Procedure
> > > > >
> > > > > BEGIN
> > > > >
> > > > > SELECT nID, sName FROM MyStore;
> > > > > //Here how can i stored this select statement result.
> > > > >
> > > > > END
> > > > >
> > > > > Thanks in Advance.
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
> >
>
>