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.

suppress repeating values

3 posts in DataWindow Last posting was on 2008-05-27 21:48:28.0Z
cln Posted on 2008-05-26 21:38:02.0Z
Sender: 33ed.483b2631.1804289383@sybase.com
From: cln
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: suppress repeating values
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <483b2dba.354a.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 26 May 2008 14:38:02 -0700
X-Trace: forums-1-dub 1211837882 10.22.241.41 (26 May 2008 14:38:02 -0700)
X-Original-Trace: 26 May 2008 14:38:02 -0700, 10.22.241.41
Lines: 22
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:86955
Article PK: 416213

I have 10 columns in a datwindow and the first 4 I have set
to 'suppress repeating values' so only the first row
displays them. I want the users to be able to edit 2 of
those columns. The problem is that as soon as they edit
either of them, the line below shows the columns that were
suppressed because they were the same that are now
different.

The problem is that I want to hide this 'refresh' display.
I want to apply the edit that just took place to all the
rows that had the same value. I can update the datawindow
with the change and re-retrieve, but before it gets updated
it's confusing to the users and this seems kind of klugy
anyway.

It seems to me there should be a way to apply the change to
all that were suppressed because they were the same value
before or at least to not have it refresh immediately in the
datawindow, before I have a chance to issue the update and
re-retrieve. Is there a way to do this or a better approach
to the whole idea?
Thanks for any info.


"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel Posted on 2008-05-27 01:34:01.0Z
From: "Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <483b2dba.354a.1681692777@sybase.com>
Subject: Re: suppress repeating values
Lines: 32
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5512
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <483b6509@forums-1-dub>
Date: 26 May 2008 18:34:01 -0700
X-Trace: forums-1-dub 1211852041 10.22.241.152 (26 May 2008 18:34:01 -0700)
X-Original-Trace: 26 May 2008 18:34:01 -0700, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:86957
Article PK: 416214

Try this:
In ItemChanged, for the relevant columns,
SetRedraw (FALSE)
Loop through the rows, applying changes as appropriate
GroupCalc()
SetRedraw(TRUE)

<cln> wrote in message news:483b2dba.354a.1681692777@sybase.com...
>I have 10 columns in a datwindow and the first 4 I have set
> to 'suppress repeating values' so only the first row
> displays them. I want the users to be able to edit 2 of
> those columns. The problem is that as soon as they edit
> either of them, the line below shows the columns that were
> suppressed because they were the same that are now
> different.
>
> The problem is that I want to hide this 'refresh' display.
> I want to apply the edit that just took place to all the
> rows that had the same value. I can update the datawindow
> with the change and re-retrieve, but before it gets updated
> it's confusing to the users and this seems kind of klugy
> anyway.
>
> It seems to me there should be a way to apply the change to
> all that were suppressed because they were the same value
> before or at least to not have it refresh immediately in the
> datawindow, before I have a chance to issue the update and
> re-retrieve. Is there a way to do this or a better approach
> to the whole idea?
> Thanks for any info.


cln Posted on 2008-05-27 21:48:28.0Z
Sender: 33ed.483b2631.1804289383@sybase.com
From: cln
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: suppress repeating values
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <483c81ac.6839.1681692777@sybase.com>
References: <483b6509@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 27 May 2008 14:48:28 -0700
X-Trace: forums-1-dub 1211924908 10.22.241.41 (27 May 2008 14:48:28 -0700)
X-Original-Trace: 27 May 2008 14:48:28 -0700, 10.22.241.41
Lines: 34
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:86971
Article PK: 416228

Worked like a charm. Thanks alot!

> Try this:
> In ItemChanged, for the relevant columns,
> SetRedraw (FALSE)
> Loop through the rows, applying changes as appropriate
> GroupCalc()
> SetRedraw(TRUE)
>
> <cln> wrote in message
> news:483b2dba.354a.1681692777@sybase.com... >I have 10
> > columns in a datwindow and the first 4 I have set to
> > 'suppress repeating values' so only the first row
> > displays them. I want the users to be able to edit 2 of
> > those columns. The problem is that as soon as they edit
> > either of them, the line below shows the columns that
> > were suppressed because they were the same that are now
> different. >
> > The problem is that I want to hide this 'refresh'
> > display. I want to apply the edit that just took place
> > to all the rows that had the same value. I can update
> > the datawindow with the change and re-retrieve, but
> > before it gets updated it's confusing to the users and
> > this seems kind of klugy anyway.
> >
> > It seems to me there should be a way to apply the change
> > to all that were suppressed because they were the same
> > value before or at least to not have it refresh
> > immediately in the datawindow, before I have a chance to
> > issue the update and re-retrieve. Is there a way to do
> > this or a better approach to the whole idea?
> > Thanks for any info.
>
>