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.

Groups breaking up incorrectly

4 posts in DataWindow Last posting was on 2008-06-09 20:43:41.0Z
cln Posted on 2008-06-09 19:17:29.0Z
Sender: 1101.484d7eb4.1804289383@sybase.com
From: cln
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Groups breaking up incorrectly
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <484d81c9.119f.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 9 Jun 2008 12:17:29 -0700
X-Trace: forums-1-dub 1213039049 10.22.241.41 (9 Jun 2008 12:17:29 -0700)
X-Original-Trace: 9 Jun 2008 12:17:29 -0700, 10.22.241.41
Lines: 24
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87124
Article PK: 416381

I have a group on rows in my datawindow and a line drawn in
the group header. Let's say all the groups have 10 rows
within them. What's happening is that during run time,
everything looks and works great, but if I use the scroll
bar to scroll down, whatever group was at the bottom of the
page gets broken into 2 groups and my line in the header
shows up too. The group header columns look exactly the
same. So it really looks like there are 2 different groups
with the same headers but with lines 1-4 in one and lines
5-6 in the other.

I've tested it with less data and more and it's definitely
NOT data related. It's whatever row ends up at the bottom
of the datawindow control (so the first one that was not
visible, but then is visible as you scroll).

I've messed around with GroupCalc() and the Reset Page Count
property, and redraw() within the ScrollVertical event, but
it still seems to happen everytime I start scrolling down.

Any ideas? Is there another 'group redraw on scroll down'
type property? Also, when I scroll down a page at a time,
it's fine because the page down is exactly the same place I
think, but row by row scrolling shows the problem.


"Jason 'Bug' Fenter [TeamSybase]" <NO_SPAMMING_jason.fenter_ Posted on 2008-06-09 19:50:33.0Z
From: "Jason 'Bug' Fenter [TeamSybase]" <NO_SPAMMING_jason.fenter_@_teamsybase.com>
User-Agent: Thunderbird 2.0.0.14 (Windows/20080421)
MIME-Version: 1.0
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Groups breaking up incorrectly
References: <484d81c9.119f.1681692777@sybase.com>
In-Reply-To: <484d81c9.119f.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <484d8989$1@forums-1-dub>
Date: 9 Jun 2008 12:50:33 -0700
X-Trace: forums-1-dub 1213041033 10.22.241.152 (9 Jun 2008 12:50:33 -0700)
X-Original-Trace: 9 Jun 2008 12:50:33 -0700, vip152.sybase.com
Lines: 34
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87125
Article PK: 416382

Your group is spanning multiple display pages. You might try the "New
Page on Group Break" option, but if your group refuses to fit on a
single page, then you'll get multiple headers. You don't mention what
version of PowerBuilder you're using, but I think PB10.5 introduced
"autosize height" on all bands. You could use some kind of expression to
hide the header when appropriate.

cln wrote:
> I have a group on rows in my datawindow and a line drawn in
> the group header. Let's say all the groups have 10 rows
> within them. What's happening is that during run time,
> everything looks and works great, but if I use the scroll
> bar to scroll down, whatever group was at the bottom of the
> page gets broken into 2 groups and my line in the header
> shows up too. The group header columns look exactly the
> same. So it really looks like there are 2 different groups
> with the same headers but with lines 1-4 in one and lines
> 5-6 in the other.
>
> I've tested it with less data and more and it's definitely
> NOT data related. It's whatever row ends up at the bottom
> of the datawindow control (so the first one that was not
> visible, but then is visible as you scroll).
>
> I've messed around with GroupCalc() and the Reset Page Count
> property, and redraw() within the ScrollVertical event, but
> it still seems to happen everytime I start scrolling down.
>
> Any ideas? Is there another 'group redraw on scroll down'
> type property? Also, when I scroll down a page at a time,
> it's fine because the page down is exactly the same place I
> think, but row by row scrolling shows the problem.


cln Posted on 2008-06-09 20:41:55.0Z
Sender: 1101.484d7eb4.1804289383@sybase.com
From: cln
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Groups breaking up incorrectly
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <484d9593.15a0.1681692777@sybase.com>
References: <484d8989$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 9 Jun 2008 13:41:55 -0700
X-Trace: forums-1-dub 1213044115 10.22.241.41 (9 Jun 2008 13:41:55 -0700)
X-Original-Trace: 9 Jun 2008 13:41:55 -0700, 10.22.241.41
Lines: 41
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87126
Article PK: 416383

Well, I do want as many groups as possible to show on a page
so the "New Page on Group Break" option isn't going to work
out for me. Do you know if there is a way to disable
scrolling row by row and only enable scrolling page by page?

> Your group is spanning multiple display pages. You might
> try the "New Page on Group Break" option, but if your
> group refuses to fit on a single page, then you'll get
> multiple headers. You don't mention what version of
> PowerBuilder you're using, but I think PB10.5 introduced
> "autosize height" on all bands. You could use some kind of
> expression to hide the header when appropriate.
>
>
>
> cln wrote:
> > I have a group on rows in my datawindow and a line drawn
> > in the group header. Let's say all the groups have 10
> > rows within them. What's happening is that during run
> > time, everything looks and works great, but if I use the
> > scroll bar to scroll down, whatever group was at the
> > bottom of the page gets broken into 2 groups and my line
> > in the header shows up too. The group header columns
> > look exactly the same. So it really looks like there are
> > 2 different groups with the same headers but with lines
> > 1-4 in one and lines 5-6 in the other.
> >
> > I've tested it with less data and more and it's
> > definitely NOT data related. It's whatever row ends up
> > at the bottom of the datawindow control (so the first
> > one that was not visible, but then is visible as you
> > scroll).
> > I've messed around with GroupCalc() and the Reset Page
> > Count property, and redraw() within the ScrollVertical
> > event, but it still seems to happen everytime I start
> > scrolling down.
> > Any ideas? Is there another 'group redraw on scroll
> > down' type property? Also, when I scroll down a page at
> > a time, it's fine because the page down is exactly the
> > same place I think, but row by row scrolling shows the
> problem.


cln Posted on 2008-06-09 20:43:41.0Z
Sender: 1101.484d7eb4.1804289383@sybase.com
From: cln
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Groups breaking up incorrectly
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <484d95fd.15b2.1681692777@sybase.com>
References: <484d9593.15a0.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 9 Jun 2008 13:43:41 -0700
X-Trace: forums-1-dub 1213044221 10.22.241.41 (9 Jun 2008 13:43:41 -0700)
X-Original-Trace: 9 Jun 2008 13:43:41 -0700, 10.22.241.41
Lines: 46
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87127
Article PK: 416384

Or is there a way to not allow a group to start if the
entire group won't fit on that page, then just start that
one group at the top of the next page?

> Well, I do want as many groups as possible to show on a
> page so the "New Page on Group Break" option isn't going
> to work out for me. Do you know if there is a way to
> disable scrolling row by row and only enable scrolling
> page by page?
>
> > Your group is spanning multiple display pages. You might
> > try the "New Page on Group Break" option, but if your
> > group refuses to fit on a single page, then you'll get
> > multiple headers. You don't mention what version of
> > PowerBuilder you're using, but I think PB10.5 introduced
> > "autosize height" on all bands. You could use some kind
> > of expression to hide the header when appropriate.
> >
> >
> >
> > cln wrote:
> > > I have a group on rows in my datawindow and a line
> > > drawn in the group header. Let's say all the groups
> > > have 10 rows within them. What's happening is that
> > > during run time, everything looks and works great, but
> > > if I use the scroll bar to scroll down, whatever group
> > > was at the bottom of the page gets broken into 2
> > > groups and my line in the header shows up too. The
> > > group header columns look exactly the same. So it
> > > really looks like there are 2 different groups with
> > > the same headers but with lines 1-4 in one and lines
> > 5-6 in the other. >
> > > I've tested it with less data and more and it's
> > > definitely NOT data related. It's whatever row ends
> > > up at the bottom of the datawindow control (so the
> > > first one that was not visible, but then is visible as
> > > you scroll).
> > > I've messed around with GroupCalc() and the Reset Page
> > > Count property, and redraw() within the ScrollVertical
> > > event, but it still seems to happen everytime I start
> > > scrolling down.
> > > Any ideas? Is there another 'group redraw on scroll
> > > down' type property? Also, when I scroll down a page
> > > at a time, it's fine because the page down is exactly
> > > the same place I think, but row by row scrolling shows
> > the problem.