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.

Nested of Store Procedure

2 posts in DataWindow Last posting was on 2008-07-23 16:42:23.0Z
Enrique Montalvan Posted on 2008-07-22 02:23:40.0Z
From: "Enrique Montalvan" <emontalvan@gruponuevomundo.com.pe>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Nested of Store Procedure
Lines: 68
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_NextPart_000_0191_01C8EB77.7844CEB0"
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <488544ac$1@forums-1-dub>
Date: 21 Jul 2008 19:23:40 -0700
X-Trace: forums-1-dub 1216693420 10.22.241.152 (21 Jul 2008 19:23:40 -0700)
X-Original-Trace: 21 Jul 2008 19:23:40 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87426
Article PK: 416682

Hi All:
 
I work with Poweruilder 10, and Sybase 12.5
 
I have a Datawindow with source StoreProcedure, in this datawindow I inserted Other datawindow nested.
This last also have the same source (the store procedure) but It is grouped of other columns, is a summary of data.
 
When a retrieve the principal, the datawindow nested also retrieve all rows, and Do not respect your own grouping.
 
I dont find the same of the nested datawindow respect your own grouping.
 
Thanks for all
 
Enrique


"John Olson [Team Sybase]" <john.olson Posted on 2008-07-23 16:42:23.0Z
From: "John Olson [Team Sybase]" <john.olson@nospam_teamsybase.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <488544ac$1@forums-1-dub>
Subject: Re: Nested of Store Procedure
Lines: 101
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_NextPart_000_0081_01C8ECA8.646F8470"
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.3138
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <48875f6f@forums-1-dub>
Date: 23 Jul 2008 09:42:23 -0700
X-Trace: forums-1-dub 1216831343 10.22.241.152 (23 Jul 2008 09:42:23 -0700)
X-Original-Trace: 23 Jul 2008 09:42:23 -0700, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87436
Article PK: 416691

The stored procedure should return values based on the passed arguments. I suggest running with trace on or database debugging to make sure the SP is being called as it should. If it isn't then recheck your code.
 
Regards,
John
"Enrique Montalvan" <emontalvan@gruponuevomundo.com.pe> wrote in message news:488544ac$1@forums-1-dub...
Hi All:
 
I work with Poweruilder 10, and Sybase 12.5
 
I have a Datawindow with source StoreProcedure, in this datawindow I inserted Other datawindow nested.
This last also have the same source (the store procedure) but It is grouped of other columns, is a summary of data.
 
When a retrieve the principal, the datawindow nested also retrieve all rows, and Do not respect your own grouping.
 
I dont find the same of the nested datawindow respect your own grouping.
 
Thanks for all
 
Enrique