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.

Filtering a DDDW

3 posts in DataWindow Last posting was on 2009-04-05 02:58:15.0Z
Enrique Posted on 2009-04-05 02:04:33.0Z
Reply-To: "Enrique" <eperezchxx@hotmail.com>
From: "Enrique" <eperezchxx@hotmail.com>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Filtering a DDDW
Lines: 11
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6001.18000
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6001.18049
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49d811b1@forums-1-dub>
Date: 4 Apr 2009 18:04:33 -0800
X-Trace: forums-1-dub 1238897073 10.22.241.152 (4 Apr 2009 18:04:33 -0800)
X-Original-Trace: 4 Apr 2009 18:04:33 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89115
Article PK: 418365

I have a datawindow with two columns
column1, column2
both columns have a DDDW but I want to filter DDDW for column2 based on the
selection of column1.
Once DDDW for column2 is filtered then all rows where the value for column2
is not in the filtered DDDW are showing the code.
Is there any workaround for this?
Any help would be appreciated
Thanks
Enrique


HarryLai Posted on 2009-04-05 02:24:41.0Z
From: "HarryLai" <nospam_harrylhy@bigfoot.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <49d811b1@forums-1-dub>
In-Reply-To: <49d811b1@forums-1-dub>
Subject: Re: Filtering a DDDW
Lines: 6
X-Priority: 3
X-MSMail-Priority: Normal
Importance: Normal
X-Newsreader: Microsoft Windows Live Mail 14.0.8064.206
X-MimeOLE: Produced By Microsoft MimeOLE V14.0.8064.206
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49d81669$1@forums-1-dub>
Date: 4 Apr 2009 18:24:41 -0800
X-Trace: forums-1-dub 1238898281 10.22.241.152 (4 Apr 2009 18:24:41 -0800)
X-Original-Trace: 4 Apr 2009 18:24:41 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89116
Article PK: 418367

AFAIK, in itemchanged event, you can declare a varible with the datatype of datawindowchild, then use GetChild() to obtain the dddw
for column2, then use setfilter() and filter() to filter the colum2 data.


"Enrique" <eperezchxx@hotmail.com> ????????? 49d811b1@forums-1-dub ???...

> I have a datawindow with two columns
> column1, column2
> both columns have a DDDW but I want to filter DDDW for column2 based on the selection of column1.
> Once DDDW for column2 is filtered then all rows where the value for column2 is not in the filtered DDDW are showing the code.
> Is there any workaround for this?
> Any help would be appreciated
> Thanks
> Enrique


"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel Posted on 2009-04-05 02:58:15.0Z
From: "Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <49d811b1@forums-1-dub>
Subject: Re: Filtering a DDDW
Lines: 26
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: <49d81e47$1@forums-1-dub>
Date: 4 Apr 2009 18:58:15 -0800
X-Trace: forums-1-dub 1238900295 10.22.241.152 (4 Apr 2009 18:58:15 -0800)
X-Original-Trace: 4 Apr 2009 18:58:15 -0800, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:89117
Article PK: 418369

That is the standard behavior for DDDW - if it can't find the data value to
look up it shows the data.
If you want to show the display values in rows other than the current row
where the DDDW is filtered the standard workaround is to have two
superimposed copies of the column with the filtered version visible in the
current row and the unfiltered version in all other rows.

--
Report Bugs: http://case-express.sybase.com/cx/welcome.do
Product Enhancement Requests:
http://my.isug.com/cgi-bin/1/c/submit_enhancement

"Enrique" <eperezchxx@hotmail.com> wrote in message
news:49d811b1@forums-1-dub...
>I have a datawindow with two columns
> column1, column2
> both columns have a DDDW but I want to filter DDDW for column2 based on
> the selection of column1.
> Once DDDW for column2 is filtered then all rows where the value for
> column2 is not in the filtered DDDW are showing the code.
> Is there any workaround for this?
> Any help would be appreciated
> Thanks
> Enrique