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.

Need dot notation

6 posts in DataWindow Last posting was on 2008-05-19 18:49:08.0Z
Sharon Posted on 2008-05-16 15:34:09.0Z
Sender: 26e5.482da8ce.1804289383@sybase.com
From: Sharon
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Need dot notation
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <482da971.2702.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 16 May 2008 08:34:09 -0700
X-Trace: forums-1-dub 1210952049 10.22.241.41 (16 May 2008 08:34:09 -0700)
X-Original-Trace: 16 May 2008 08:34:09 -0700, 10.22.241.41
Lines: 7
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:86877
Article PK: 416134

I have a report called dw_report
It has a nested report called dw_1
I need to access the information on dw_1.
All of the visible information is in the trailer band.

How do I loop through the rows in the trailer band to access
the fields there?


scionyx Posted on 2008-05-16 16:53:15.0Z
From: scionyx <sfield@scionyx.com>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Need dot notation
Date: Fri, 16 May 2008 09:53:15 -0700 (PDT)
Organization: http://groups.google.com
Lines: 21
Message-ID: <9b34a44a-76f5-4ad7-a9e3-91eca60025a9@b5g2000pri.googlegroups.com>
References: <482da971.2702.1681692777@sybase.com>
NNTP-Posting-Host: 158.228.211.10
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1210956795 20242 127.0.0.1 (16 May 2008 16:53:15 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 16 May 2008 16:53:15 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: b5g2000pri.googlegroups.com; posting-host=158.228.211.10; posting-account=-kzySgkAAAAqb7jiNSJ1XKXlAz27meBa
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; InfoPath.1; .NET CLR 2.0.50727),gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!newsfeed.gamma.ru!Gamma.RU!newsfeed.icl.net!newsfeed.fjserv.net!nx01.iad01.newshosting.com!newshosting.com!198.186.194.249.MISMATCH!news-out.readnews.com!transit3.readnews.com!postnews.google.com!b5g2000pri.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:86878
Article PK: 416136

The long form is:
dw_report.object.dw_1[report_row].object.xxx[local_row]

Nominally, report_row = 1, and you would be looping through local_row.

IF the configuration is shallow, you can use GetChild() to grab dw_1,
and then treat that variable as the target.

HTH

Steve

On May 16, 8:34 am, Sharon wrote:
> I have a report called dw_report
> It has a nested report called dw_1
> I need to access the information on dw_1.
> All of the visible information is in the trailer band.
>
> How do I loop through the rows in the trailer band to access
> the fields there?


Sharon Posted on 2008-05-16 17:05:09.0Z
Sender: 26e5.482da8ce.1804289383@sybase.com
From: sharon
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Need dot notation
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <482dbec5.2bbd.1681692777@sybase.com>
References: <9b34a44a-76f5-4ad7-a9e3-91eca60025a9@b5g2000pri.googlegroups.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 16 May 2008 10:05:09 -0700
X-Trace: forums-1-dub 1210957509 10.22.241.41 (16 May 2008 10:05:09 -0700)
X-Original-Trace: 16 May 2008 10:05:09 -0700, 10.22.241.41
Lines: 27
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:86879
Article PK: 416139

thank you,
but how do I get the number of rows for local_row?
Sharon

> The long form is:
>
> dw_report.object.dw_1[report_row].object.xxx[local_row]
>
> Nominally, report_row = 1, and you would be looping
> through local_row.
>
> IF the configuration is shallow, you can use GetChild() to
> grab dw_1, and then treat that variable as the target.
>
> HTH
>
> Steve
>
> On May 16, 8:34 am, Sharon wrote:
> > I have a report called dw_report
> > It has a nested report called dw_1
> > I need to access the information on dw_1.
> > All of the visible information is in the trailer band.
> >
> > How do I loop through the rows in the trailer band to
> > access the fields there?
>


Larry Molter Posted on 2008-05-19 12:32:47.0Z
From: "Larry Molter" <lmolter1@tampabay.rr.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <482da971.2702.1681692777@sybase.com> <9b34a44a-76f5-4ad7-a9e3-91eca60025a9@b5g2000pri.googlegroups.com>
Subject: Re: Need dot notation
Lines: 29
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4831736f$1@forums-1-dub>
Date: 19 May 2008 05:32:47 -0700
X-Trace: forums-1-dub 1211200367 10.22.241.152 (19 May 2008 05:32:47 -0700)
X-Original-Trace: 19 May 2008 05:32:47 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:86888
Article PK: 416146

However, for nested reports, you cannot use getChild() on the nested report.
Only works for composite reports.

Larry

"scionyx" <sfield@scionyx.com> wrote in message
news:9b34a44a-76f5-4ad7-a9e3-91eca60025a9@b5g2000pri.googlegroups.com...
The long form is:
dw_report.object.dw_1[report_row].object.xxx[local_row]

Nominally, report_row = 1, and you would be looping through local_row.

IF the configuration is shallow, you can use GetChild() to grab dw_1,
and then treat that variable as the target.

HTH

Steve

On May 16, 8:34 am, Sharon wrote:
> I have a report called dw_report
> It has a nested report called dw_1
> I need to access the information on dw_1.
> All of the visible information is in the trailer band.
>
> How do I loop through the rows in the trailer band to access
> the fields there?


scionyx Posted on 2008-05-19 18:49:08.0Z
From: scionyx <sfield@scionyx.com>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Need dot notation
Date: Mon, 19 May 2008 11:49:08 -0700 (PDT)
Organization: http://groups.google.com
Lines: 37
Message-ID: <a38e769a-4f69-43e4-a5b9-568b6d1a8ec1@w4g2000prd.googlegroups.com>
References: <482da971.2702.1681692777@sybase.com> <9b34a44a-76f5-4ad7-a9e3-91eca60025a9@b5g2000pri.googlegroups.com> <4831736f$1@forums-1-dub>
NNTP-Posting-Host: 158.228.211.10
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1211222948 1343 127.0.0.1 (19 May 2008 18:49:08 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Mon, 19 May 2008 18:49:08 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: w4g2000prd.googlegroups.com; posting-host=158.228.211.10; posting-account=-kzySgkAAAAqb7jiNSJ1XKXlAz27meBa
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; InfoPath.1; .NET CLR 2.0.50727),gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!newsfeed.gamma.ru!Gamma.RU!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.freenet.de!feeder.news-service.com!postnews.google.com!w4g2000prd.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:86890
Article PK: 416148

Sorry if that's confusing. I use the word "shallow" to mean
composite, where the nested reports are renderable (leaf nodes).

Composite
Leaf1
Leaf2
Leaf...

You can use GetChild to grab any leaf by name (and that's how you
should know if it's in the trailer band, etc.)

Composite
Leaf1
CompositeA
...
CompositeB
CompositeB1
Leaf B1a
CompositeB2
...

This is the "deep" type of thing I have to deal with. Many
intermediate branches. GetChild is useless for all practical
purposes.

HTH

Steve

On May 19, 5:32 am, "Larry Molter" <lmolt...@tampabay.rr.com> wrote:
> However, for nested reports, you cannot use getChild() on the nested report.
> Only works for composite reports.
>
> Larry
>