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.

Problem with describe on nested reports

2 posts in DataWindow Last posting was on 2009-03-17 21:00:12.0Z
Brian Prom Posted on 2009-03-13 14:20:10.0Z
Sender: 6674.49ba61ca.1804289383@sybase.com
From: Brian Prom
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Problem with describe on nested reports
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <49ba6b9a.674f.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 13 Mar 2009 06:20:10 -0800
X-Trace: forums-1-dub 1236954010 10.22.241.41 (13 Mar 2009 06:20:10 -0800)
X-Original-Trace: 13 Mar 2009 06:20:10 -0800, 10.22.241.41
Lines: 17
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88958
Article PK: 418208

Hello,
I am having a problem getting the syntax right for a
describe function that tells me if a nested report has data
for a certain row on the main driver datawindow. I am able
to get dot notation to work, but can't seem to get it
working for describe. Can anyone help me convert this dot
notation to describe syntax...

ads_report.Object.dw_1[ll_ctr].Object.DataWindow.Data

I need to use describe because I am creating the driver dw
on the fly and won't know how many nested reports or how may
rows the driver returns. I need to know if the nested
reports for each row has data or not.

Thanks,
- Brian


scionyx Posted on 2009-03-17 21:00:12.0Z
From: scionyx <sfield@scionyx.com>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Problem with describe on nested reports
Date: Tue, 17 Mar 2009 14:00:12 -0700 (PDT)
Organization: http://groups.google.com
Lines: 44
Message-ID: <1e69238f-7a5e-42f2-b26b-9764dc63efa5@y33g2000prg.googlegroups.com>
References: <49ba6b9a.674f.1681692777@sybase.com>
NNTP-Posting-Host: 170.104.61.146
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1237323612 4760 127.0.0.1 (17 Mar 2009 21:00:12 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 17 Mar 2009 21:00:12 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: y33g2000prg.googlegroups.com; posting-host=170.104.61.146; posting-account=-kzySgkAAAAqb7jiNSJ1XKXlAz27meBa
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .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!nntp1.phx1.gblx.net!nntp.gblx.net!nntp.gblx.net!border2.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!y33g2000prg.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88996
Article PK: 418250

Did you get an answer?

I did some work with reports a while ago and basically, if you have
Composite-Nested (1 layer) you can use GetChildDW() to grab nested
report objects and possibly use descibe on those. If the layering is
deeper, Composite-Nested-Nested-..., (the problem I worked on), you
MUST use dot notation and wrap it in Try/catch blocks. This is so you
can catch an attempt to access a node that does not exist because the
SQL returned no results.

For example, in your case, you would loop on ll_ctr and get an
Exception when it fails. then (ll_ctr - 1) is the number of rows.

Agian, for your shallow case, you could do:
childdatawindow ldwc
ads_report.GetChildDW(dw_1, ldwc)

rowcount = ldwc.RowCount();

yadda yadda.

Is the the direction you are going?

Steve

On Mar 13, 7:20 am, Brian Prom wrote:
> Hello,
>         I am having a problem getting the syntax right for a
> describe function that tells me if a nested report has data
> for a certain row on the main driver datawindow.  I am able
> to get dot notation to work, but can't seem to get it
> working for describe.  Can anyone help me convert this dot
> notation to describe syntax...
>
> ads_report.Object.dw_1[ll_ctr].Object.DataWindow.Data
>
> I need to use describe because I am creating the driver dw
> on the fly and won't know how many nested reports or how may
> rows the driver returns.  I need to know if the nested
> reports for each row has data or not.
>
> Thanks,
> - Brian