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.

PB Crashes on DW Modify

5 posts in DataWindow Last posting was on 2009-11-09 15:55:27.0Z
Joelle Posted on 2009-11-02 21:10:54.0Z
From: Joelle <joelleboutros@gmail.com>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: PB Crashes on DW Modify
Date: Mon, 2 Nov 2009 13:10:54 -0800 (PST)
Organization: http://groups.google.com
Lines: 18
Message-ID: <31e3ce98-febb-484d-a928-3ab25a23021a@b2g2000yqi.googlegroups.com>
NNTP-Posting-Host: 142.177.129.101
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
X-Trace: posting.google.com 1257196254 15223 127.0.0.1 (2 Nov 2009 21:10:54 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Mon, 2 Nov 2009 21:10:54 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: b2g2000yqi.googlegroups.com; posting-host=142.177.129.101; posting-account=B_4A6QoAAACjiks6uNTvR7oVjlJrlM8I
User-Agent: G2/1.0
X-HTTP-Via: 1.0 NSHALPROXY03
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 2.0.50727; .NET CLR 1.1.4322),gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!newsfeed.yul.equant.net!novia!news-out.readnews.com!news-xxxfer.readnews.com!postnews.google.com!b2g2000yqi.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90196
Article PK: 409802

Hi,

I am trying to modify a text control that is in the Header[1] band of
a crosstab dw. I am using the following syntax:

ls_title = This.Describe("st_subtitle.Text") // this works
This.Modify("st_subtitle.Text=test") // this causes PB to crash

I also tried the dot notation instead of using modify():

This.Object.st_subtitle.Text = 'test' // this also causes PB to crash

The same code used to work prior to upgrading to 10.5.

Any ideas?

Thanks!
Joelle


Ivaylo Ivanov Posted on 2009-11-03 09:52:53.0Z
From: "Ivaylo Ivanov" <n0_S_p_a_m_i.ivanov@isy-dc.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <31e3ce98-febb-484d-a928-3ab25a23021a@b2g2000yqi.googlegroups.com>
Subject: Re: PB Crashes on DW Modify
Lines: 47
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4aeffd75$1@forums-1-dub>
Date: 3 Nov 2009 01:52:53 -0800
X-Trace: forums-1-dub 1257241973 10.22.241.152 (3 Nov 2009 01:52:53 -0800)
X-Original-Trace: 3 Nov 2009 01:52:53 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90201
Article PK: 409806

What about putting quotes around the value you assign:
This.Modify("st_subtitle.Text='test'")

Is your text control above a dynamic crosstab column? Give us more
information.

Another idea: if your crosstab is in dynamic mode, try to switch temporarily
to static mode, make your modifications and then return back to dynamic
mode. Example:

// Switch the crosstab to static mode
boolean lb_switched = FALSE
if Lower(this.Describe("DataWindow.Crosstab.StaticMode")) <> "yes" then
this.Modify("Datawindow.Crosstab.StaticMode='yes'")
lb_switched = TRUE
end if

// ... your Modify comes here

// Switch the crosstab back to dynamic mode
if lb_switched then this.Modify("Datawindow.Crosstab.StaticMode='no'")

Regards,
Ivaylo

"Joelle" <joelleboutros@gmail.com> wrote in message
news:31e3ce98-febb-484d-a928-3ab25a23021a@b2g2000yqi.googlegroups.com...
> Hi,
>
> I am trying to modify a text control that is in the Header[1] band of
> a crosstab dw. I am using the following syntax:
>
> ls_title = This.Describe("st_subtitle.Text") // this works
> This.Modify("st_subtitle.Text=test") // this causes PB to crash
>
> I also tried the dot notation instead of using modify():
>
> This.Object.st_subtitle.Text = 'test' // this also causes PB to crash
>
> The same code used to work prior to upgrading to 10.5.
>
> Any ideas?
>
> Thanks!
> Joelle


Joelle Posted on 2009-11-05 16:41:20.0Z
From: Joelle <joelleboutros@gmail.com>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: PB Crashes on DW Modify
Date: Thu, 5 Nov 2009 08:41:20 -0800 (PST)
Organization: http://groups.google.com
Lines: 57
Message-ID: <b91bfd01-8e65-49bc-bd6d-60bd871aaee1@m26g2000yqb.googlegroups.com>
References: <31e3ce98-febb-484d-a928-3ab25a23021a@b2g2000yqi.googlegroups.com> <4aeffd75$1@forums-1-dub>
NNTP-Posting-Host: 142.177.129.101
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1257439281 14687 127.0.0.1 (5 Nov 2009 16:41:21 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 5 Nov 2009 16:41:21 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: m26g2000yqb.googlegroups.com; posting-host=142.177.129.101; posting-account=B_4A6QoAAACjiks6uNTvR7oVjlJrlM8I
User-Agent: G2/1.0
X-HTTP-Via: 1.0 NSHALPROXY03
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 2.0.50727; .NET CLR 1.1.4322),gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!newsfeed.yul.equant.net!news-raspail.gip.net!news.gsl.net!gip.net!aotearoa.belnet.be!news.belnet.be!newsfeed.kpn.net!pfeed09.wxs.nl!xlned.com!feeder1.xlned.com!feeder3.cambriumusenet.nl!feed.tweaknews.nl!193.201.147.78.MISMATCH!feeder.news-service.com!postnews.google.com!m26g2000yqb.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90226
Article PK: 409832

On Nov 3, 4:52 am, "Ivaylo Ivanov" <n0_S_p_a_m_i.iva...@isy-dc.com>

wrote:
> What about putting quotes around the value you assign:
> This.Modify("st_subtitle.Text='test'")
>
> Is your text control above a dynamic crosstab column? Give us more
> information.
>
> Another idea: if your crosstab is in dynamic mode, try to switch temporarily
> to static mode, make your modifications and then return back to dynamic
> mode. Example:
>
> // Switch the crosstab to static mode
> boolean lb_switched = FALSE
> if Lower(this.Describe("DataWindow.Crosstab.StaticMode")) <> "yes" then
>    this.Modify("Datawindow.Crosstab.StaticMode='yes'")
>    lb_switched = TRUE
> end if
>
> // ... your Modify comes here
>
> // Switch the crosstab back to dynamic mode
> if lb_switched then this.Modify("Datawindow.Crosstab.StaticMode='no'")
>
> Regards,
> Ivaylo
>
> "Joelle" <joellebout...@gmail.com> wrote in message
>
> news:31e3ce98-febb-484d-a928-3ab25a23021a@b2g2000yqi.googlegroups.com...
>
>
>
> > Hi,
>
> > I am trying to modify a text control that is in the Header[1] band of
> > a crosstab dw. I am using the following syntax:
>
> > ls_title = This.Describe("st_subtitle.Text") // this works
> > This.Modify("st_subtitle.Text=test") // this causes PB tocrash
>
> > I also tried the dot notation instead of using modify():
>
> > This.Object.st_subtitle.Text = 'test' // this also causes PB tocrash
>
> > The same code used to work prior to upgrading to 10.5.
>
> > Any ideas?
>
> > Thanks!
> > Joelle- Hide quoted text -
>
> - Show quoted text -

Switching the crosstab to static mode before the modify worked. Thank
you!


Joelle Posted on 2009-11-09 14:47:26.0Z
From: Joelle <joelleboutros@gmail.com>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: PB Crashes on DW Modify
Date: Mon, 9 Nov 2009 06:47:26 -0800 (PST)
Organization: http://groups.google.com
Lines: 99
Message-ID: <94b1c860-5d33-43c8-9cbd-a7977a435727@g31g2000vbr.googlegroups.com>
References: <31e3ce98-febb-484d-a928-3ab25a23021a@b2g2000yqi.googlegroups.com> <4aeffd75$1@forums-1-dub> <b91bfd01-8e65-49bc-bd6d-60bd871aaee1@m26g2000yqb.googlegroups.com>
NNTP-Posting-Host: 142.177.129.100
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1257778046 9353 127.0.0.1 (9 Nov 2009 14:47:26 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Mon, 9 Nov 2009 14:47:26 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: g31g2000vbr.googlegroups.com; posting-host=142.177.129.100; posting-account=B_4A6QoAAACjiks6uNTvR7oVjlJrlM8I
User-Agent: G2/1.0
X-HTTP-Via: 1.0 NSHALPROXY02
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 2.0.50727; .NET CLR 1.1.4322),gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!newsfeed.yul.equant.net!novia!news-out.readnews.com!transit4.readnews.com!postnews.google.com!g31g2000vbr.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90231
Article PK: 409835


On Nov 5, 11:41 am, Joelle <joellebout...@gmail.com> wrote:
> On Nov 3, 4:52 am, "Ivaylo Ivanov" <n0_S_p_a_m_i.iva...@isy-dc.com>
> wrote:
>
>
>
>
>
> > What about putting quotes around the value you assign:
> > This.Modify("st_subtitle.Text='test'")
>
> > Is your text control above a dynamic crosstab column? Give us more
> > information.
>
> > Another idea: if your crosstab is in dynamic mode, try to switch temporarily
> > to static mode, make your modifications and then return back to dynamic
> > mode. Example:
>
> > // Switch the crosstab to static mode
> > boolean lb_switched = FALSE
> > if Lower(this.Describe("DataWindow.Crosstab.StaticMode")) <> "yes" then
> >    this.Modify("Datawindow.Crosstab.StaticMode='yes'")
> >    lb_switched = TRUE
> > end if
>
> > // ... your Modify comes here
>
> > // Switch the crosstab back to dynamic mode
> > if lb_switched then this.Modify("Datawindow.Crosstab.StaticMode='no'")
>
> > Regards,
> > Ivaylo
>
> > "Joelle" <joellebout...@gmail.com> wrote in message
>
> >news:31e3ce98-febb-484d-a928-3ab25a23021a@b2g2000yqi.googlegroups.com...
>
> > > Hi,
>
> > > I am trying to modify a text control that is in the Header[1] band of
> > > a crosstab dw. I am using the following syntax:
>
> > > ls_title = This.Describe("st_subtitle.Text") // this works
> > > This.Modify("st_subtitle.Text=test") // this causes PB tocrash
>
> > > I also tried the dot notation instead of using modify():
>
> > > This.Object.st_subtitle.Text = 'test' // this also causes PB tocrash
>
> > > The same code used to work prior to upgrading to 10.5.
>
> > > Any ideas?
>
> > > Thanks!
> > > Joelle- Hide quoted text -
>
> > - Show quoted text -
>
> Switching the crosstab to static mode before the modify worked. Thank
> you!- Hide quoted text -
>
> - Show quoted text -

Hi,

Ivaylo's suggestion worked in that PB no longer crashes. However, for
some reason, my text control st_subtitle does not get updated with the
new value:

// Switch the crosstab to static mode
boolean lb_switched = FALSE
if Lower(this.Describe("DataWindow.Crosstab.StaticMode")) <> "yes"
then
this.Modify("Datawindow.Crosstab.StaticMode='yes'")
lb_switched = TRUE
end if

// Modify comes here
ls_title = This.Describe("st_subtitle.Text") // this works
OpenWithParm (wn_prompt_4_report_title, ls_title) //this opens a
window for the user to edit the current subtitle
this.Object.st_subtitle.text = Message.StringParm //message.stringparm
has the right value BUT st_subtitle is not being updated with the new
value.

// Switch the crosstab back to dynamic mode
if lb_switched then this.Modify("Datawindow.Crosstab.StaticMode='no'")

//Is there a refresh issue here????
this.Object.DataWindow.Print.Preview= 'Yes' //the new value is
displayed when I do this...why?
this.Object.DataWindow.Print.Preview= 'No'

//this does not pick up the new value...why?
ls_title = This.Describe("st_subtitle.Text")


Ivaylo Ivanov Posted on 2009-11-09 15:55:27.0Z
From: "Ivaylo Ivanov" <n0_S_p_a_m_i.ivanov@isy-dc.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <31e3ce98-febb-484d-a928-3ab25a23021a@b2g2000yqi.googlegroups.com> <4aeffd75$1@forums-1-dub> <b91bfd01-8e65-49bc-bd6d-60bd871aaee1@m26g2000yqb.googlegroups.com> <94b1c860-5d33-43c8-9cbd-a7977a435727@g31g2000vbr.googlegroups.com>
Subject: Re: PB Crashes on DW Modify
Lines: 114
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4af83b6f@forums-1-dub>
Date: 9 Nov 2009 07:55:27 -0800
X-Trace: forums-1-dub 1257782127 10.22.241.152 (9 Nov 2009 07:55:27 -0800)
X-Original-Trace: 9 Nov 2009 07:55:27 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90232
Article PK: 409837

First question of all: is your "st_subtitle" object a dynamically
multiplicated header title (eg upon a dynamic crosstab column) or a static
one?

Second: have you tried with some this.SetRedraw(FALSE) +
this.SetRedraw(TRUE) ?

Third: you can try the opposite approach - keep your DW most of the time in
static mode and temporarily switch it to dynamic mode just for the
retrieval. After that, return it back to static mode.

Regards,
Ivaylo

"Joelle" <joelleboutros@gmail.com> wrote in message
news:94b1c860-5d33-43c8-9cbd-a7977a435727@g31g2000vbr.googlegroups.com...

On Nov 5, 11:41 am, Joelle <joellebout...@gmail.com> wrote:
> On Nov 3, 4:52 am, "Ivaylo Ivanov" <n0_S_p_a_m_i.iva...@isy-dc.com>
> wrote:
>
>
>
>
>
> > What about putting quotes around the value you assign:
> > This.Modify("st_subtitle.Text='test'")
>
> > Is your text control above a dynamic crosstab column? Give us more
> > information.
>
> > Another idea: if your crosstab is in dynamic mode, try to switch
> > temporarily
> > to static mode, make your modifications and then return back to dynamic
> > mode. Example:
>
> > // Switch the crosstab to static mode
> > boolean lb_switched = FALSE
> > if Lower(this.Describe("DataWindow.Crosstab.StaticMode")) <> "yes" then
> > this.Modify("Datawindow.Crosstab.StaticMode='yes'")
> > lb_switched = TRUE
> > end if
>
> > // ... your Modify comes here
>
> > // Switch the crosstab back to dynamic mode
> > if lb_switched then this.Modify("Datawindow.Crosstab.StaticMode='no'")
>
> > Regards,
> > Ivaylo
>
> > "Joelle" <joellebout...@gmail.com> wrote in message
>
> >news:31e3ce98-febb-484d-a928-3ab25a23021a@b2g2000yqi.googlegroups.com...
>
> > > Hi,
>
> > > I am trying to modify a text control that is in the Header[1] band of
> > > a crosstab dw. I am using the following syntax:
>
> > > ls_title = This.Describe("st_subtitle.Text") // this works
> > > This.Modify("st_subtitle.Text=test") // this causes PB tocrash
>
> > > I also tried the dot notation instead of using modify():
>
> > > This.Object.st_subtitle.Text = 'test' // this also causes PB tocrash
>
> > > The same code used to work prior to upgrading to 10.5.
>
> > > Any ideas?
>
> > > Thanks!
> > > Joelle- Hide quoted text -
>
> > - Show quoted text -
>
> Switching the crosstab to static mode before the modify worked. Thank
> you!- Hide quoted text -
>
> - Show quoted text -

Hi,

Ivaylo's suggestion worked in that PB no longer crashes. However, for
some reason, my text control st_subtitle does not get updated with the
new value:

// Switch the crosstab to static mode
boolean lb_switched = FALSE
if Lower(this.Describe("DataWindow.Crosstab.StaticMode")) <> "yes"
then
this.Modify("Datawindow.Crosstab.StaticMode='yes'")
lb_switched = TRUE
end if

// Modify comes here
ls_title = This.Describe("st_subtitle.Text") // this works
OpenWithParm (wn_prompt_4_report_title, ls_title) //this opens a
window for the user to edit the current subtitle
this.Object.st_subtitle.text = Message.StringParm //message.stringparm
has the right value BUT st_subtitle is not being updated with the new
value.

// Switch the crosstab back to dynamic mode
if lb_switched then this.Modify("Datawindow.Crosstab.StaticMode='no'")

//Is there a refresh issue here????
this.Object.DataWindow.Print.Preview= 'Yes' //the new value is
displayed when I do this...why?
this.Object.DataWindow.Print.Preview= 'No'

//this does not pick up the new value...why?
ls_title = This.Describe("st_subtitle.Text")