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.

Retrieving DW with Sybase stored procedure - result set not found

3 posts in DataWindow Last posting was on 2008-05-10 13:03:02.0Z
Brian Posted on 2008-05-09 16:32:05.0Z
Sender: 4f2f.4824631d.1804289383@sybase.com
From: Brian
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Retrieving DW with Sybase stored procedure - result set not found
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <48247c85.54f6.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 9 May 2008 09:32:05 -0700
X-Trace: forums-1-dub 1210350725 10.22.241.41 (9 May 2008 09:32:05 -0700)
X-Original-Trace: 9 May 2008 09:32:05 -0700, 10.22.241.41
Lines: 25
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:86797
Article PK: 416056

PB version 8.0.4 Build 10784 (will upgrade to 11.0 June 1)
Sybase version 12.5.3

I select the grid datwindow type, then I select 'Stored
Procedure' for the datasource. I then select the stored
procedure I would like to use. Move through the defaults
and save the DW. I include the DW on window#1 and the DW is
populated as expected.

However, when I go to another window and return to window#1,
I get error "requested result set number 1 not found."

This error also occurs if I launch PB and go to one of the
other windows and then to window#1.

I browsed the forum and based upon other solutions, I (1)
set Autocommit = true and (2) created new datawindow,
source=stored procedure and manually defined columns, but
none of this did any good.

Any ideas?

Thanks!

Brian


Millard F. Brown III Posted on 2008-05-09 20:04:40.0Z
From: "Millard F. Brown III" <millard.brown@teamsybase.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <48247c85.54f6.1681692777@sybase.com>
Subject: Re: Retrieving DW with Sybase stored procedure - result set not found
Lines: 34
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4824ae58$1@forums-1-dub>
Date: 9 May 2008 13:04:40 -0700
X-Trace: forums-1-dub 1210363480 10.22.241.152 (9 May 2008 13:04:40 -0700)
X-Original-Trace: 9 May 2008 13:04:40 -0700, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:86798
Article PK: 416057

Where are you executing the retrieve, and what does the code look like?

--
Regards,
Millard [TeamSybase]

<Brian> wrote in message news:48247c85.54f6.1681692777@sybase.com...
> PB version 8.0.4 Build 10784 (will upgrade to 11.0 June 1)
> Sybase version 12.5.3
>
> I select the grid datwindow type, then I select 'Stored
> Procedure' for the datasource. I then select the stored
> procedure I would like to use. Move through the defaults
> and save the DW. I include the DW on window#1 and the DW is
> populated as expected.
>
> However, when I go to another window and return to window#1,
> I get error "requested result set number 1 not found."
>
> This error also occurs if I launch PB and go to one of the
> other windows and then to window#1.
>
> I browsed the forum and based upon other solutions, I (1)
> set Autocommit = true and (2) created new datawindow,
> source=stored procedure and manually defined columns, but
> none of this did any good.
>
> Any ideas?
>
> Thanks!
>
> Brian


"Paul Horan[TeamSybase]" Posted on 2008-05-10 13:03:02.0Z
From: "Paul Horan[TeamSybase]" <phoran AT sybase DOT com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <48247c85.54f6.1681692777@sybase.com>
Subject: Re: Retrieving DW with Sybase stored procedure - result set not found
Lines: 39
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <48259d06@forums-1-dub>
Date: 10 May 2008 06:03:02 -0700
X-Trace: forums-1-dub 1210424582 10.22.241.152 (10 May 2008 06:03:02 -0700)
X-Original-Trace: 10 May 2008 06:03:02 -0700, vip152.sybase.com
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:86799
Article PK: 416059

PB will actually execute your procedure with "default" values to determine
the shape of the result set. If that call results in an early exit (a
return with no result set), you'll get this message.

Here's what I do. Strip out all the code (or just comment it) in the proc
except for the SELECT statement that returns the desired result set. Then
paint the datawindow, and then uncomment all that code in the proc. Works
every time...

Paul Horan[TeamSybase]

<Brian> wrote in message news:48247c85.54f6.1681692777@sybase.com...
> PB version 8.0.4 Build 10784 (will upgrade to 11.0 June 1)
> Sybase version 12.5.3
>
> I select the grid datwindow type, then I select 'Stored
> Procedure' for the datasource. I then select the stored
> procedure I would like to use. Move through the defaults
> and save the DW. I include the DW on window#1 and the DW is
> populated as expected.
>
> However, when I go to another window and return to window#1,
> I get error "requested result set number 1 not found."
>
> This error also occurs if I launch PB and go to one of the
> other windows and then to window#1.
>
> I browsed the forum and based upon other solutions, I (1)
> set Autocommit = true and (2) created new datawindow,
> source=stored procedure and manually defined columns, but
> none of this did any good.
>
> Any ideas?
>
> Thanks!
>
> Brian