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

6 posts in DataWindow Last posting was on 2008-10-01 13:46:41.0Z
Enrique Posted on 2008-09-30 19:59:34.0Z
Sender: 199f.48e27c77.1804289383@sybase.com
From: Enrique
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Filtering a DDDW
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <48e28526.1aa2.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 30 Sep 2008 12:59:34 -0700
X-Trace: forums-1-dub 1222804774 10.22.241.41 (30 Sep 2008 12:59:34 -0700)
X-Original-Trace: 30 Sep 2008 12:59:34 -0700, 10.22.241.41
Lines: 17
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87887
Article PK: 417142

This is my problem

I have two columns

Column1 and column2
1 d1 description
2 d2 description

Column2 has a DDDW that I want to filter based on column1
value.
My problem is that when I filter the DDDW, say row 1 by
column1 value (1), then I miss the description on row 2.
Any idea how to avoid this?
Any workaround?
Any help would be very appreciated.
Thanks
Enrique


"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel Posted on 2008-09-30 20:06:23.0Z
From: "Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <48e28526.1aa2.1681692777@sybase.com>
Subject: Re: Filtering a DDDW
Lines: 22
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
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: <48e286bf$1@forums-1-dub>
Date: 30 Sep 2008 13:06:23 -0700
X-Trace: forums-1-dub 1222805183 10.22.241.152 (30 Sep 2008 13:06:23 -0700)
X-Original-Trace: 30 Sep 2008 13:06:23 -0700, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87888
Article PK: 417144

XFAQ. See my answer to Mauro, posted yesterday.

<Enrique> wrote in message news:48e28526.1aa2.1681692777@sybase.com...
> This is my problem
>
> I have two columns
>
> Column1 and column2
> 1 d1 description
> 2 d2 description
>
> Column2 has a DDDW that I want to filter based on column1
> value.
> My problem is that when I filter the DDDW, say row 1 by
> column1 value (1), then I miss the description on row 2.
> Any idea how to avoid this?
> Any workaround?
> Any help would be very appreciated.
> Thanks
> Enrique


Brad Wery[TeamSybase] Posted on 2008-09-30 20:08:11.0Z
From: "Brad Wery[TeamSybase]" <bradweryatgmail.com>
User-Agent: Thunderbird 2.0.0.17 (Windows/20080914)
MIME-Version: 1.0
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Filtering a DDDW
References: <48e28526.1aa2.1681692777@sybase.com>
In-Reply-To: <48e28526.1aa2.1681692777@sybase.com>
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: <48e2872b$1@forums-1-dub>
Date: 30 Sep 2008 13:08:11 -0700
X-Trace: forums-1-dub 1222805291 10.22.241.152 (30 Sep 2008 13:08:11 -0700)
X-Original-Trace: 30 Sep 2008 13:08:11 -0700, vip152.sybase.com
Lines: 48
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87889
Article PK: 417145

This is expected behaviour. The only workaround I know of is to have two
columns that overlap each other. One has the dddw and the other is just
a normal column which will store the description of the underlying data.
You would just have to add an expression to each columns visible
property. Something like this:

for dddw:
if(currentrow() = getrow(), 1,0)

for fake column
if(currentrow() = getrow(), 0,1)

Something like that. I didn't test the expression.

Brad

Enrique wrote:
> This is my problem
>
> I have two columns
>
> Column1 and column2
> 1 d1 description
> 2 d2 description
>
> Column2 has a DDDW that I want to filter based on column1
> value.
> My problem is that when I filter the DDDW, say row 1 by
> column1 value (1), then I miss the description on row 2.
> Any idea how to avoid this?
> Any workaround?
> Any help would be very appreciated.
> Thanks
> Enrique

--

*********************************************************************************
www.PowerToTheBuilder.com

- Take control of your GUI with a free PB user control library
- Get updates from by blog - www.PowerToTheBuilder.com/blog

*********************************************************************************
Submit a PowerBuilder Success Story
www.PowerToTheBuilder.com/success.aspx

*********************************************************************************


Mike Stoffel Posted on 2008-09-30 21:35:02.0Z
From: "Mike Stoffel" <mstoffel@ipsdelivers.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <48e28526.1aa2.1681692777@sybase.com> <48e2872b$1@forums-1-dub>
In-Reply-To: <48e2872b$1@forums-1-dub>
Subject: Re: Filtering a DDDW
Lines: 55
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6000.16480
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6000.16669
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <48e29b86$1@forums-1-dub>
Date: 30 Sep 2008 14:35:02 -0700
X-Trace: forums-1-dub 1222810502 10.22.241.152 (30 Sep 2008 14:35:02 -0700)
X-Original-Trace: 30 Sep 2008 14:35:02 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87890
Article PK: 417146

I prefer the SetDetailHeight(0) method to "filter" the dddw since the
overlapping columns don't work easily with grid datawindows.

Mike

"Brad Wery[TeamSybase]" <bradweryatgmail.com> wrote in message
news:48e2872b$1@forums-1-dub...
> This is expected behaviour. The only workaround I know of is to have two
> columns that overlap each other. One has the dddw and the other is just a
> normal column which will store the description of the underlying data. You
> would just have to add an expression to each columns visible property.
> Something like this:
>
> for dddw:
> if(currentrow() = getrow(), 1,0)
>
> for fake column
> if(currentrow() = getrow(), 0,1)
>
> Something like that. I didn't test the expression.
>
> Brad
>
> Enrique wrote:
>> This is my problem
>>
>> I have two columns
>>
>> Column1 and column2
>> 1 d1 description 2 d2 description
>>
>> Column2 has a DDDW that I want to filter based on column1
>> value.
>> My problem is that when I filter the DDDW, say row 1 by
>> column1 value (1), then I miss the description on row 2.
>> Any idea how to avoid this?
>> Any workaround?
>> Any help would be very appreciated.
>> Thanks
>> Enrique
>
> --
>
> *********************************************************************************
> www.PowerToTheBuilder.com
>
> - Take control of your GUI with a free PB user control library
> - Get updates from by blog - www.PowerToTheBuilder.com/blog
>
> *********************************************************************************
> Submit a PowerBuilder Success Story
> www.PowerToTheBuilder.com/success.aspx
>
> *********************************************************************************


"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel Posted on 2008-09-30 23:28:08.0Z
From: "Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <48e28526.1aa2.1681692777@sybase.com> <48e2872b$1@forums-1-dub> <48e29b86$1@forums-1-dub>
Subject: Re: Filtering a DDDW
Lines: 62
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <48e2b608@forums-1-dub>
Date: 30 Sep 2008 16:28:08 -0700
X-Trace: forums-1-dub 1222817288 10.22.241.152 (30 Sep 2008 16:28:08 -0700)
X-Original-Trace: 30 Sep 2008 16:28:08 -0700, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87891
Article PK: 417148

The problem with that is that ItemChanged will fire for each "excluded"
value if the user navigates using the arrow keys.

"Mike Stoffel" <mstoffel@ipsdelivers.com> wrote in message
news:48e29b86$1@forums-1-dub...
>I prefer the SetDetailHeight(0) method to "filter" the dddw since the
>overlapping columns don't work easily with grid datawindows.
>
> Mike
>
> "Brad Wery[TeamSybase]" <bradweryatgmail.com> wrote in message
> news:48e2872b$1@forums-1-dub...
>> This is expected behaviour. The only workaround I know of is to have two
>> columns that overlap each other. One has the dddw and the other is just a
>> normal column which will store the description of the underlying data.
>> You would just have to add an expression to each columns visible
>> property. Something like this:
>>
>> for dddw:
>> if(currentrow() = getrow(), 1,0)
>>
>> for fake column
>> if(currentrow() = getrow(), 0,1)
>>
>> Something like that. I didn't test the expression.
>>
>> Brad
>>
>> Enrique wrote:
>>> This is my problem
>>>
>>> I have two columns
>>>
>>> Column1 and column2
>>> 1 d1 description 2 d2 description
>>>
>>> Column2 has a DDDW that I want to filter based on column1
>>> value.
>>> My problem is that when I filter the DDDW, say row 1 by
>>> column1 value (1), then I miss the description on row 2.
>>> Any idea how to avoid this?
>>> Any workaround?
>>> Any help would be very appreciated.
>>> Thanks
>>> Enrique
>>
>> --
>>
>> *********************************************************************************
>> www.PowerToTheBuilder.com
>>
>> - Take control of your GUI with a free PB user control library
>> - Get updates from by blog - www.PowerToTheBuilder.com/blog
>>
>> *********************************************************************************
>> Submit a PowerBuilder Success Story
>> www.PowerToTheBuilder.com/success.aspx
>>
>> *********************************************************************************
>


Mike Stoffel Posted on 2008-10-01 13:46:41.0Z
From: "Mike Stoffel" <mstoffel@ipsdelivers.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <48e28526.1aa2.1681692777@sybase.com> <48e2872b$1@forums-1-dub> <48e29b86$1@forums-1-dub> <48e2b608@forums-1-dub>
In-Reply-To: <48e2b608@forums-1-dub>
Subject: Re: Filtering a DDDW
Lines: 70
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6000.16480
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6000.16669
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <48e37f41$1@forums-1-dub>
Date: 1 Oct 2008 06:46:41 -0700
X-Trace: forums-1-dub 1222868801 10.22.241.152 (1 Oct 2008 06:46:41 -0700)
X-Original-Trace: 1 Oct 2008 06:46:41 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87895
Article PK: 417149

This article has the code to avoid the arrow key issue along with some other
interesting DDDW info. http://de.sys-con.com/node/42519

Mike

"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com> wrote in message
news:48e2b608@forums-1-dub...
> The problem with that is that ItemChanged will fire for each "excluded"
> value if the user navigates using the arrow keys.
>
> "Mike Stoffel" <mstoffel@ipsdelivers.com> wrote in message
> news:48e29b86$1@forums-1-dub...
>>I prefer the SetDetailHeight(0) method to "filter" the dddw since the
>>overlapping columns don't work easily with grid datawindows.
>>
>> Mike
>>
>> "Brad Wery[TeamSybase]" <bradweryatgmail.com> wrote in message
>> news:48e2872b$1@forums-1-dub...
>>> This is expected behaviour. The only workaround I know of is to have two
>>> columns that overlap each other. One has the dddw and the other is just
>>> a normal column which will store the description of the underlying data.
>>> You would just have to add an expression to each columns visible
>>> property. Something like this:
>>>
>>> for dddw:
>>> if(currentrow() = getrow(), 1,0)
>>>
>>> for fake column
>>> if(currentrow() = getrow(), 0,1)
>>>
>>> Something like that. I didn't test the expression.
>>>
>>> Brad
>>>
>>> Enrique wrote:
>>>> This is my problem
>>>>
>>>> I have two columns
>>>>
>>>> Column1 and column2
>>>> 1 d1 description 2 d2 description
>>>>
>>>> Column2 has a DDDW that I want to filter based on column1
>>>> value.
>>>> My problem is that when I filter the DDDW, say row 1 by
>>>> column1 value (1), then I miss the description on row 2.
>>>> Any idea how to avoid this?
>>>> Any workaround?
>>>> Any help would be very appreciated.
>>>> Thanks
>>>> Enrique
>>>
>>> --
>>>
>>> *********************************************************************************
>>> www.PowerToTheBuilder.com
>>>
>>> - Take control of your GUI with a free PB user control library
>>> - Get updates from by blog - www.PowerToTheBuilder.com/blog
>>>
>>> *********************************************************************************
>>> Submit a PowerBuilder Success Story
>>> www.PowerToTheBuilder.com/success.aspx
>>>
>>> *********************************************************************************
>>
>
>