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 DataWindowChild

7 posts in DataWindow Last posting was on 2008-03-28 16:06:22.0Z
Jason Lipman Posted on 2008-03-27 21:22:03.0Z
From: "Jason Lipman" <NOSPAM-jlipman@oppenheimer>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Filtering DataWindowChild
Lines: 14
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <47ec0ffb$1@forums-1-dub>
Date: 27 Mar 2008 13:22:03 -0800
X-Trace: forums-1-dub 1206652923 10.22.241.152 (27 Mar 2008 13:22:03 -0800)
X-Original-Trace: 27 Mar 2008 13:22:03 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:86539
Article PK: 415799

PB 10.5

I need to filter the contents of a DataWindowChild in a dropdown row by row.
The problem is that when I use ldcw_child.Filter, it applies the filter to
all the rows. I am using the PFC dropdown event to do the filter. I have
also tried in the rowfocuschanged event.. same problem.

Anyone know how to do this properly?

Thanks!!

Jason Lipman


Jason 'Bug' Fenter [TeamSybase] Posted on 2008-03-27 21:44:28.0Z
From: "Jason 'Bug' Fenter [TeamSybase]" <jason.fenter@teamsybase.com>
User-Agent: Thunderbird 2.0.0.12 (Windows/20080213)
MIME-Version: 1.0
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Filtering DataWindowChild
References: <47ec0ffb$1@forums-1-dub>
In-Reply-To: <47ec0ffb$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <47ec153c$1@forums-1-dub>
Date: 27 Mar 2008 13:44:28 -0800
X-Trace: forums-1-dub 1206654268 10.22.241.152 (27 Mar 2008 13:44:28 -0800)
X-Original-Trace: 27 Mar 2008 13:44:28 -0800, vip152.sybase.com
Lines: 20
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:86541
Article PK: 415802


Jason Lipman wrote:
> PB 10.5
>
> I need to filter the contents of a DataWindowChild in a dropdown row by row.
> The problem is that when I use ldcw_child.Filter, it applies the filter to
> all the rows. I am using the PFC dropdown event to do the filter. I have
> also tried in the rowfocuschanged event.. same problem.
>
> Anyone know how to do this properly?
>
> Thanks!!
>
> Jason Lipman

This has been asked many times. The approach I prefer is to have two
copies of the column object, both with dddw edit styles. One is visible
on all rows that that child is not filtered. The other is only visible
on the current row and is filtered accordingly. Try Googling these
newsgroups for more specific details.


Jason Lipman Posted on 2008-03-27 21:58:33.0Z
From: "Jason Lipman" <NOSPAM-jlipman@oppenheimer>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <47ec0ffb$1@forums-1-dub> <47ec153c$1@forums-1-dub>
Subject: Re: Filtering DataWindowChild
Lines: 30
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.3198
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <47ec1889$1@forums-1-dub>
Date: 27 Mar 2008 13:58:33 -0800
X-Trace: forums-1-dub 1206655113 10.22.241.152 (27 Mar 2008 13:58:33 -0800)
X-Original-Trace: 27 Mar 2008 13:58:33 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:86543
Article PK: 415803

That makes sense if the filter is the same for all the rows getting the
filter. But in my scenario, there can be three different ways I want to
filter. I think my problem remains based on the method you described.

Jason Lipman

"Jason 'Bug' Fenter [TeamSybase]" <jason.fenter@teamsybase.com> wrote in
message news:47ec153c$1@forums-1-dub...
> Jason Lipman wrote:
>> PB 10.5
>>
>> I need to filter the contents of a DataWindowChild in a dropdown row by
>> row. The problem is that when I use ldcw_child.Filter, it applies the
>> filter to all the rows. I am using the PFC dropdown event to do the
>> filter. I have also tried in the rowfocuschanged event.. same problem.
>>
>> Anyone know how to do this properly?
>>
>> Thanks!!
>>
>> Jason Lipman
>
>
> This has been asked many times. The approach I prefer is to have two
> copies of the column object, both with dddw edit styles. One is visible on
> all rows that that child is not filtered. The other is only visible on the
> current row and is filtered accordingly. Try Googling these newsgroups for
> more specific details.


"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel Posted on 2008-03-28 00:00:18.0Z
From: "Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <47ec0ffb$1@forums-1-dub> <47ec153c$1@forums-1-dub> <47ec1889$1@forums-1-dub>
Subject: Re: Filtering DataWindowChild
Lines: 37
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <47ec3512$1@forums-1-dub>
Date: 27 Mar 2008 16:00:18 -0800
X-Trace: forums-1-dub 1206662418 10.22.241.152 (27 Mar 2008 16:00:18 -0800)
X-Original-Trace: 27 Mar 2008 16:00:18 -0800, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:86545
Article PK: 415805

What happened when you tried filtering the filtered copy of the column in
the rowfocusshanged event?

"Jason Lipman" <NOSPAM-jlipman@oppenheimer> wrote in message
news:47ec1889$1@forums-1-dub...
> That makes sense if the filter is the same for all the rows getting the
> filter. But in my scenario, there can be three different ways I want to
> filter. I think my problem remains based on the method you described.
>
> Jason Lipman
>
> "Jason 'Bug' Fenter [TeamSybase]" <jason.fenter@teamsybase.com> wrote in
> message news:47ec153c$1@forums-1-dub...
>> Jason Lipman wrote:
>>> PB 10.5
>>>
>>> I need to filter the contents of a DataWindowChild in a dropdown row by
>>> row. The problem is that when I use ldcw_child.Filter, it applies the
>>> filter to all the rows. I am using the PFC dropdown event to do the
>>> filter. I have also tried in the rowfocuschanged event.. same problem.
>>>
>>> Anyone know how to do this properly?
>>>
>>> Thanks!!
>>>
>>> Jason Lipman
>>
>>
>> This has been asked many times. The approach I prefer is to have two
>> copies of the column object, both with dddw edit styles. One is visible
>> on all rows that that child is not filtered. The other is only visible on
>> the current row and is filtered accordingly. Try Googling these
>> newsgroups for more specific details.
>
>


Jason 'Bug' Fenter [TeamSybase] Posted on 2008-03-28 14:05:36.0Z
From: "Jason 'Bug' Fenter [TeamSybase]" <jason.fenter@teamsybase.com>
User-Agent: Thunderbird 2.0.0.12 (Windows/20080213)
MIME-Version: 1.0
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Filtering DataWindowChild
References: <47ec0ffb$1@forums-1-dub> <47ec153c$1@forums-1-dub> <47ec1889$1@forums-1-dub>
In-Reply-To: <47ec1889$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <47ecfb30$1@forums-1-dub>
Date: 28 Mar 2008 06:05:36 -0800
X-Trace: forums-1-dub 1206713136 10.22.241.152 (28 Mar 2008 06:05:36 -0800)
X-Original-Trace: 28 Mar 2008 06:05:36 -0800, vip152.sybase.com
Lines: 51
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:86558
Article PK: 415818

I guess that didn't come across as clear as I had hoped. You have two
copies of the column. One copy is not filtered at all; it contains every
display value that is possible on every row. It is also visible on every
row, so every row look correct.

The second copy is only visible on the row you're editing. It replaces
the unfiltered version, so you only see the filtered version. Because
it's only visible on one row, you can change the filter dynamically and
it won't affect the display of all of the other rows.

Yes, the filtering has to be done in PowerScript; there's no way to get
a dw expression to dynamically filter.

So in your RowFocusChanged event, you would:
1. Make the "unfiltered" dddw visible on all rows *except* the new
current row
2. Make the "filtered" dddw visible on *only* the new current row
3. Change the filter on the "filtered" dddw so that it applies to the
new current row.

Jason Lipman wrote:
> That makes sense if the filter is the same for all the rows getting the
> filter. But in my scenario, there can be three different ways I want to
> filter. I think my problem remains based on the method you described.
>
> Jason Lipman
>
> "Jason 'Bug' Fenter [TeamSybase]" <jason.fenter@teamsybase.com> wrote in
> message news:47ec153c$1@forums-1-dub...
>> Jason Lipman wrote:
>>> PB 10.5
>>>
>>> I need to filter the contents of a DataWindowChild in a dropdown row by
>>> row. The problem is that when I use ldcw_child.Filter, it applies the
>>> filter to all the rows. I am using the PFC dropdown event to do the
>>> filter. I have also tried in the rowfocuschanged event.. same problem.
>>>
>>> Anyone know how to do this properly?
>>>
>>> Thanks!!
>>>
>>> Jason Lipman
>>
>> This has been asked many times. The approach I prefer is to have two
>> copies of the column object, both with dddw edit styles. One is visible on
>> all rows that that child is not filtered. The other is only visible on the
>> current row and is filtered accordingly. Try Googling these newsgroups for
>> more specific details.
>
>


"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel Posted on 2008-03-28 15:00:55.0Z
From: "Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <47ec0ffb$1@forums-1-dub> <47ec153c$1@forums-1-dub> <47ec1889$1@forums-1-dub> <47ecfb30$1@forums-1-dub>
Subject: Re: Filtering DataWindowChild
Lines: 60
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <47ed0827$1@forums-1-dub>
Date: 28 Mar 2008 07:00:55 -0800
X-Trace: forums-1-dub 1206716455 10.22.241.152 (28 Mar 2008 07:00:55 -0800)
X-Original-Trace: 28 Mar 2008 07:00:55 -0800, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:86559
Article PK: 415819

Two more pointers from my experience:
The two copies of the column are superimposed - both the same size and
position. This is OK because only one will be visible on any given row.
Visibility is easily handled by the Visible expression : for the
display-only unfiltered column, if(getrow() = currentrow(), 0, 1) and for
the updateable, filtered column if(getrow() = currentrow(), 1, 0)

"Jason 'Bug' Fenter [TeamSybase]" <jason.fenter@teamsybase.com> wrote in
message news:47ecfb30$1@forums-1-dub...
>I guess that didn't come across as clear as I had hoped. You have two
>copies of the column. One copy is not filtered at all; it contains every
>display value that is possible on every row. It is also visible on every
>row, so every row look correct.
>
> The second copy is only visible on the row you're editing. It replaces the
> unfiltered version, so you only see the filtered version. Because it's
> only visible on one row, you can change the filter dynamically and it
> won't affect the display of all of the other rows.
>
> Yes, the filtering has to be done in PowerScript; there's no way to get a
> dw expression to dynamically filter.
>
> So in your RowFocusChanged event, you would:
> 1. Make the "unfiltered" dddw visible on all rows *except* the new current
> row
> 2. Make the "filtered" dddw visible on *only* the new current row
> 3. Change the filter on the "filtered" dddw so that it applies to the new
> current row.
>
>
> Jason Lipman wrote:
>> That makes sense if the filter is the same for all the rows getting the
>> filter. But in my scenario, there can be three different ways I want to
>> filter. I think my problem remains based on the method you described.
>>
>> Jason Lipman
>>
>> "Jason 'Bug' Fenter [TeamSybase]" <jason.fenter@teamsybase.com> wrote in
>> message news:47ec153c$1@forums-1-dub...
>>> Jason Lipman wrote:
>>>> PB 10.5
>>>>
>>>> I need to filter the contents of a DataWindowChild in a dropdown row by
>>>> row. The problem is that when I use ldcw_child.Filter, it applies the
>>>> filter to all the rows. I am using the PFC dropdown event to do the
>>>> filter. I have also tried in the rowfocuschanged event.. same problem.
>>>>
>>>> Anyone know how to do this properly?
>>>>
>>>> Thanks!!
>>>>
>>>> Jason Lipman
>>>
>>> This has been asked many times. The approach I prefer is to have two
>>> copies of the column object, both with dddw edit styles. One is visible
>>> on all rows that that child is not filtered. The other is only visible
>>> on the current row and is filtered accordingly. Try Googling these
>>> newsgroups for more specific details.
>>


Jason Lipman Posted on 2008-03-28 16:06:22.0Z
From: "Jason Lipman" <NOSPAM-jlipman@oppenheimer>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <47ec0ffb$1@forums-1-dub> <47ec153c$1@forums-1-dub> <47ec1889$1@forums-1-dub> <47ecfb30$1@forums-1-dub> <47ed0827$1@forums-1-dub>
Subject: Re: Filtering DataWindowChild
Lines: 72
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <47ed177e$1@forums-1-dub>
Date: 28 Mar 2008 08:06:22 -0800
X-Trace: forums-1-dub 1206720382 10.22.241.152 (28 Mar 2008 08:06:22 -0800)
X-Original-Trace: 28 Mar 2008 08:06:22 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:86560
Article PK: 415820

Thanks!! I actually figured out what Jason Fenter meant from his first
response, and had already applied the "if(getrow() = currentrow(), " logic!

Thanks for the insight guys!

Jason Lipman

"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com> wrote in message
news:47ed0827$1@forums-1-dub...
> Two more pointers from my experience:
> The two copies of the column are superimposed - both the same size and
> position. This is OK because only one will be visible on any given row.
> Visibility is easily handled by the Visible expression : for the
> display-only unfiltered column, if(getrow() = currentrow(), 0, 1) and for
> the updateable, filtered column if(getrow() = currentrow(), 1, 0)
>
> "Jason 'Bug' Fenter [TeamSybase]" <jason.fenter@teamsybase.com> wrote in
> message news:47ecfb30$1@forums-1-dub...
>>I guess that didn't come across as clear as I had hoped. You have two
>>copies of the column. One copy is not filtered at all; it contains every
>>display value that is possible on every row. It is also visible on every
>>row, so every row look correct.
>>
>> The second copy is only visible on the row you're editing. It replaces
>> the unfiltered version, so you only see the filtered version. Because
>> it's only visible on one row, you can change the filter dynamically and
>> it won't affect the display of all of the other rows.
>>
>> Yes, the filtering has to be done in PowerScript; there's no way to get a
>> dw expression to dynamically filter.
>>
>> So in your RowFocusChanged event, you would:
>> 1. Make the "unfiltered" dddw visible on all rows *except* the new
>> current row
>> 2. Make the "filtered" dddw visible on *only* the new current row
>> 3. Change the filter on the "filtered" dddw so that it applies to the new
>> current row.
>>
>>
>> Jason Lipman wrote:
>>> That makes sense if the filter is the same for all the rows getting the
>>> filter. But in my scenario, there can be three different ways I want to
>>> filter. I think my problem remains based on the method you described.
>>>
>>> Jason Lipman
>>>
>>> "Jason 'Bug' Fenter [TeamSybase]" <jason.fenter@teamsybase.com> wrote in
>>> message news:47ec153c$1@forums-1-dub...
>>>> Jason Lipman wrote:
>>>>> PB 10.5
>>>>>
>>>>> I need to filter the contents of a DataWindowChild in a dropdown row
>>>>> by row. The problem is that when I use ldcw_child.Filter, it applies
>>>>> the filter to all the rows. I am using the PFC dropdown event to do
>>>>> the filter. I have also tried in the rowfocuschanged event.. same
>>>>> problem.
>>>>>
>>>>> Anyone know how to do this properly?
>>>>>
>>>>> Thanks!!
>>>>>
>>>>> Jason Lipman
>>>>
>>>> This has been asked many times. The approach I prefer is to have two
>>>> copies of the column object, both with dddw edit styles. One is visible
>>>> on all rows that that child is not filtered. The other is only visible
>>>> on the current row and is filtered accordingly. Try Googling these
>>>> newsgroups for more specific details.
>>>
>