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.

datawindow suppress repeating values does not function

2 posts in Appeon (partner product) Last posting was on 2004-11-01 08:58:55.0Z
jason Posted on 2004-10-29 11:02:56.0Z
Reply-To: "jason" <changcc@dragon.com.tw>
From: "jason" <changcc@dragon.com.tw>
Newsgroups: sybase.public.appeon
Subject: datawindow suppress repeating values does not function
Lines: 9
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
X-Original-NNTP-Posting-Host: kh210-202-31-42.vdsl.static.apol.com.tw
Message-ID: <4182235c$1@forums-2-dub>
X-Original-Trace: 29 Oct 2004 04:02:52 -0700, kh210-202-31-42.vdsl.static.apol.com.tw
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 29 Oct 2004 04:02:53 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 29 Oct 2004 04:02:56 -0700
X-Trace: forums-1-dub 1099047776 10.22.108.75 (29 Oct 2004 04:02:56 -0700)
X-Original-Trace: 29 Oct 2004 04:02:56 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:537
Article PK: 20789

hi,
I use a datawindow and suppress repeating values, but it doesn't work.
Is it right?
Appeon Version: 2.8.1 ATL

Thanks,
Jason


Julie Jiang Posted on 2004-11-01 08:58:55.0Z
From: "Julie Jiang" <julie.jiang@appeon.net>
Newsgroups: sybase.public.appeon
Organization: 61.144.207.174
References: <4182235c$1@forums-2-dub>
X-Newsreader: AspNNTP 1.50 (Takeshi Eto)
Subject: Re: datawindow suppress repeating values does not function
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: web110.discountasp.net
Message-ID: <418608da$1@forums-2-dub>
X-Original-Trace: 1 Nov 2004 01:58:50 -0700, web110.discountasp.net
Lines: 36
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 1 Nov 2004 01:58:52 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 1 Nov 2004 01:58:55 -0700
X-Trace: forums-1-dub 1099303135 10.22.108.75 (1 Nov 2004 01:58:55 -0700)
X-Original-Trace: 1 Nov 2004 01:58:55 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:547
Article PK: 12593

Hi Jason,

We can work around the suppress repeating values (sparse property) by using a
computed field.

Supposing the column that has the property enabled is column A:

Step 1 – Place a computed field in the DataWindow object as an invisible cache
to store the data values of column A.
Step 2 – In the Constructor event of the DataWindow control, copy all data
values of column A to the computed field.
Step 3 – Add an expression for the Visible property of the column A in the
DataWindow object. In the expression, compare the data values stored in column
A with those stored in the Computed field. Once the repeating value is found,
the repeating value will be invisible in the column.
Step 4 – Select Sort | Rows menu. Specify the sort column you want to suppress
in the specify sort columns window.

Note: to copy data values to the computed field, keep the first data value in
the computed field empty.

Regards,
Julie

On 29 Oct 2004 04:02:56 -0700,
in sybase.public.appeon

jason <changcc@dragon.com.tw> wrote:
>hi,
>I use a datawindow and suppress repeating values, but it doesn't work.
>Is it right?
>Appeon Version: 2.8.1 ATL
>
>Thanks,
>Jason
>
>