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.

Page() expresion function always display 1 on ultiple Pages

3 posts in DataWindow Last posting was on 2009-04-29 06:37:55.0Z
John Mendoza Posted on 2009-04-27 07:29:29.0Z
Sender: 7ab5.49f47404.1804289383@sybase.com
From: John Mendoza
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Page() expresion function always display 1 on ultiple Pages
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <49f55ed9.e90.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 27 Apr 2009 00:29:29 -0700
X-Trace: forums-1-dub 1240817369 10.22.241.41 (27 Apr 2009 00:29:29 -0700)
X-Original-Trace: 27 Apr 2009 00:29:29 -0700, 10.22.241.41
Lines: 14
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89200
Article PK: 418451

Hi,

We have a problem in PB 11.5 2506, the page() datawindow
expression function always display 1 even if there are
multiple pages to print. We have one column with
AutoSize=True. This column is the bottom column. We also
have the detail band AutoSize=True. This applies to all
datawindows of the same type described above while on
Preview Mode in the Datawindow Designer. The Print out
using the datawindow Print Function have "1 of PageCount()"
on every page.


Thanks,


Jason 'Bug' Fenter Posted on 2009-04-27 16:03:20.0Z
From: Jason 'Bug' Fenter <jason.fenter@teamsybase.com>
User-Agent: Thunderbird 2.0.0.21 (Windows/20090302)
MIME-Version: 1.0
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Page() expresion function always display 1 on ultiple Pages
References: <49f55ed9.e90.1681692777@sybase.com>
In-Reply-To: <49f55ed9.e90.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49f5d748$1@forums-1-dub>
Date: 27 Apr 2009 09:03:20 -0700
X-Trace: forums-1-dub 1240848200 10.22.241.152 (27 Apr 2009 09:03:20 -0700)
X-Original-Trace: 27 Apr 2009 09:03:20 -0700, vip152.sybase.com
Lines: 22
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89203
Article PK: 418455

If the printed page says "1 of PageCount()"... if it literally says
"pagecount", then you probably have something wrong with the quotes in
your expression. That might also explain why everything is on "page 1".
Your expression should be (and you can copy and paste this):
String ( Page ( ) ) + " of " + String ( PageCount ( ) )

John Mendoza wrote:
> Hi,
>
> We have a problem in PB 11.5 2506, the page() datawindow
> expression function always display 1 even if there are
> multiple pages to print. We have one column with
> AutoSize=True. This column is the bottom column. We also
> have the detail band AutoSize=True. This applies to all
> datawindows of the same type described above while on
> Preview Mode in the Datawindow Designer. The Print out
> using the datawindow Print Function have "1 of PageCount()"
> on every page.
>
>
> Thanks,


John Mendoza Posted on 2009-04-29 06:37:55.0Z
Sender: 4ebe.49f7f45a.1804289383@sybase.com
From: John Mendoza
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Page() expresion function always display 1 on ultiple Pages
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <49f7f5c2.4ee3.1681692777@sybase.com>
References: <49f5d748$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 28 Apr 2009 23:37:55 -0700
X-Trace: forums-1-dub 1240987075 10.22.241.41 (28 Apr 2009 23:37:55 -0700)
X-Original-Trace: 28 Apr 2009 23:37:55 -0700, 10.22.241.41
Lines: 34
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89205
Article PK: 418457

No, not literally the "1" is always 1 and PageCount() is
more like "n" meaning "1 of n". Where n is any whole number
greater the Zero.

If you Have 3 Pages to print, Page() + ' of ' + PageCount()
dislplays are:

Paper One : 1 of 3
Paper Two : 1 of 3
Paper Three : 1 of 3

> If the printed page says "1 of PageCount()"... if it
> literally says "pagecount", then you probably have
> something wrong with the quotes in your expression. That
> might also explain why everything is on "page 1". Your
> expression should be (and you can copy and paste this):
> String ( Page ( ) ) + " of " + String ( PageCount ( ) )
>
>
> John Mendoza wrote:
> > Hi,
> >
> > We have a problem in PB 11.5 2506, the page()
> > datawindow expression function always display 1 even if
> > there are multiple pages to print. We have one column
> > with AutoSize=True. This column is the bottom column.
> > We also have the detail band AutoSize=True. This
> > applies to all datawindows of the same type described
> > above while on Preview Mode in the Datawindow Designer.
> > The Print out using the datawindow Print Function have
> > "1 of PageCount()" on every page.
> >
> >
> > Thanks,