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.

Modifying Nested Report in PowerBuilder 10.5

7 posts in DataWindow Last posting was on 2010-03-10 07:43:39.0Z
Ravi Posted on 2008-12-15 16:16:59.0Z
From: "Ravi" <ravi@sawinpro.com>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Modifying Nested Report in PowerBuilder 10.5
Lines: 24
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <494682fb$1@forums-1-dub>
Date: 15 Dec 2008 08:16:59 -0800
X-Trace: forums-1-dub 1229357819 10.22.241.152 (15 Dec 2008 08:16:59 -0800)
X-Original-Trace: 15 Dec 2008 08:16:59 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88405
Article PK: 417660

Hello Everyone,

I have a report DW which contains a nested datawindow.
I am trying to dynamically modify property of one of the columns inside the
datawindow.

Name of the nested datawindow inside my report is dw_4. So to change one of
the column's "border" property I have written the following code:

dw_report.Object.dw_4.Object.serv_num.border = 1

The script errors out:

"Null object refrenced near object on line xxxx"

I have double verified the names of the control and also
check on PB help which confirms the syntax I am using here.

What am I doing wrong here ?
I am using Powerbuilder 10.5, Build 7699

RN


Chris Pollach Posted on 2008-12-15 16:41:52.0Z
From: "Chris Pollach" <cpollach@travel-net.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <494682fb$1@forums-1-dub>
Subject: Re: Modifying Nested Report in PowerBuilder 10.5
Lines: 44
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3350
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <494688d0$1@forums-1-dub>
Date: 15 Dec 2008 08:41:52 -0800
X-Trace: forums-1-dub 1229359312 10.22.241.152 (15 Dec 2008 08:41:52 -0800)
X-Original-Trace: 15 Dec 2008 08:41:52 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88407
Article PK: 417658

Hi Ravi;

Can you try it with single quotes ...
dw_report.Object.dw_4.Object.serv_num.border = '1'

FWIW: I would include this code in a TRY/Catch and also code the Error Event
on the DC/DS control to trap these errors at run time.


--
Regards ... Chris
ISUG - NA RUG Director
http://chrispollach.pbdjmagazine.com

"Ravi" <ravi@sawinpro.com> wrote in message news:494682fb$1@forums-1-dub...
> Hello Everyone,
>
> I have a report DW which contains a nested datawindow.
> I am trying to dynamically modify property of one of the columns inside
> the
> datawindow.
>
> Name of the nested datawindow inside my report is dw_4. So to change one
> of
> the column's "border" property I have written the following code:
>
> dw_report.Object.dw_4.Object.serv_num.border = 1
>
> The script errors out:
>
> "Null object refrenced near object on line xxxx"
>
> I have double verified the names of the control and also
> check on PB help which confirms the syntax I am using here.
>
> What am I doing wrong here ?
> I am using Powerbuilder 10.5, Build 7699
>
> RN
>
>


Ravi Posted on 2008-12-15 16:53:41.0Z
From: "Ravi" <ravi@sawinpro.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <494682fb$1@forums-1-dub> <494688d0$1@forums-1-dub>
Subject: Re: Modifying Nested Report in PowerBuilder 10.5
Lines: 56
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49468b95$1@forums-1-dub>
Date: 15 Dec 2008 08:53:41 -0800
X-Trace: forums-1-dub 1229360021 10.22.241.152 (15 Dec 2008 08:53:41 -0800)
X-Original-Trace: 15 Dec 2008 08:53:41 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88408
Article PK: 417663

Chris,

Yes, I have tried it. I get the same error.

RN

"Chris Pollach" <cpollach@travel-net.com> wrote in message
news:494688d0$1@forums-1-dub...
> Hi Ravi;
>
> Can you try it with single quotes ...
> dw_report.Object.dw_4.Object.serv_num.border = '1'
>
> FWIW: I would include this code in a TRY/Catch and also code the Error
> Event on the DC/DS control to trap these errors at run time.
>
>
> --
> Regards ... Chris
> ISUG - NA RUG Director
> http://chrispollach.pbdjmagazine.com
>
>
> "Ravi" <ravi@sawinpro.com> wrote in message
> news:494682fb$1@forums-1-dub...
>> Hello Everyone,
>>
>> I have a report DW which contains a nested datawindow.
>> I am trying to dynamically modify property of one of the columns inside
>> the
>> datawindow.
>>
>> Name of the nested datawindow inside my report is dw_4. So to change one
>> of
>> the column's "border" property I have written the following code:
>>
>> dw_report.Object.dw_4.Object.serv_num.border = 1
>>
>> The script errors out:
>>
>> "Null object refrenced near object on line xxxx"
>>
>> I have double verified the names of the control and also
>> check on PB help which confirms the syntax I am using here.
>>
>> What am I doing wrong here ?
>> I am using Powerbuilder 10.5, Build 7699
>>
>> RN
>>
>>
>
>


Chris Pollach Posted on 2008-12-15 17:31:21.0Z
From: "Chris Pollach" <cpollach@travel-net.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <494682fb$1@forums-1-dub> <494688d0$1@forums-1-dub> <49468b95$1@forums-1-dub>
Subject: Re: Modifying Nested Report in PowerBuilder 10.5
Lines: 77
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3350
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49469469@forums-1-dub>
Date: 15 Dec 2008 09:31:21 -0800
X-Trace: forums-1-dub 1229362281 10.22.241.152 (15 Dec 2008 09:31:21 -0800)
X-Original-Trace: 15 Dec 2008 09:31:21 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88409
Article PK: 417662

Ravi;

This code works for me ...
THIS.Object.dw_1.Object.cc_full_name.border = 1

The key is to make sure is that the nested object you have referenced
(serv_num) is actually a column residing in one of the DW's bands - not just
a column in the sql statement that does not map to a band. If the latter is
the case, the code to set the border will error.

HTH

--
Regards ... Chris
ISUG - NA RUG Director
http://chrispollach.pbdjmagazine.com

"Ravi" <ravi@sawinpro.com> wrote in message news:49468b95$1@forums-1-dub...
> Chris,
>
> Yes, I have tried it. I get the same error.
>
> RN
>
>
> "Chris Pollach" <cpollach@travel-net.com> wrote in message
> news:494688d0$1@forums-1-dub...
>> Hi Ravi;
>>
>> Can you try it with single quotes ...
>> dw_report.Object.dw_4.Object.serv_num.border = '1'
>>
>> FWIW: I would include this code in a TRY/Catch and also code the Error
>> Event on the DC/DS control to trap these errors at run time.
>>
>>
>> --
>> Regards ... Chris
>> ISUG - NA RUG Director
>> http://chrispollach.pbdjmagazine.com
>>
>>
>> "Ravi" <ravi@sawinpro.com> wrote in message
>> news:494682fb$1@forums-1-dub...
>>> Hello Everyone,
>>>
>>> I have a report DW which contains a nested datawindow.
>>> I am trying to dynamically modify property of one of the columns inside
>>> the
>>> datawindow.
>>>
>>> Name of the nested datawindow inside my report is dw_4. So to change one
>>> of
>>> the column's "border" property I have written the following code:
>>>
>>> dw_report.Object.dw_4.Object.serv_num.border = 1
>>>
>>> The script errors out:
>>>
>>> "Null object refrenced near object on line xxxx"
>>>
>>> I have double verified the names of the control and also
>>> check on PB help which confirms the syntax I am using here.
>>>
>>> What am I doing wrong here ?
>>> I am using Powerbuilder 10.5, Build 7699
>>>
>>> RN
>>>
>>>
>>
>>
>
>


Scott Morris Posted on 2008-12-15 18:29:34.0Z
From: "Scott Morris" <bogus@bogus.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <494682fb$1@forums-1-dub>
Subject: Re: Modifying Nested Report in PowerBuilder 10.5
Lines: 24
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4946a20e@forums-1-dub>
Date: 15 Dec 2008 10:29:34 -0800
X-Trace: forums-1-dub 1229365774 10.22.241.152 (15 Dec 2008 10:29:34 -0800)
X-Original-Trace: 15 Dec 2008 10:29:34 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88410
Article PK: 417664


"Ravi" <ravi@sawinpro.com> wrote in message news:494682fb$1@forums-1-dub...
> Hello Everyone,
>
> I have a report DW which contains a nested datawindow.
> I am trying to dynamically modify property of one of the columns inside
> the
> datawindow.
>
> Name of the nested datawindow inside my report is dw_4. So to change one
> of
> the column's "border" property I have written the following code:
>
> dw_report.Object.dw_4.Object.serv_num.border = 1
>
> The script errors out:
>
> "Null object refrenced near object on line xxxx"

A nested report is relative to a row - so you need to reference the
particular row of interest in your dot notation. E.g.,

dw_report.Object.dw_4[1].Object.serv_num.border = 1