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.

Dropdown DW

4 posts in Objects Last posting was on 2009-12-17 11:49:40.0Z
neil Posted on 2009-12-17 09:29:15.0Z
Sender: 1ff5.4b2850ee.1804289383@sybase.com
From: Neil
Newsgroups: sybase.public.powerbuilder.objects
Subject: Dropdown DW
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4b29f9eb.48ca.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 17 Dec 2009 01:29:15 -0800
X-Trace: forums-1-dub 1261042155 10.22.241.41 (17 Dec 2009 01:29:15 -0800)
X-Original-Trace: 17 Dec 2009 01:29:15 -0800, 10.22.241.41
Lines: 14
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.objects:9957
Article PK: 737086

Hi All, I have a problem with Dropdown DW. Example, this is
the list in the DDDW.
Code Description
1 ABC
2 ABC

I can't select the code 2, it will always return code 1,
even when I select the second line in the list which
supposedly should return the code 2.

What is the workaround on this?

Thanks,
Neil


neil Posted on 2009-12-17 09:30:59.0Z
Sender: 1ff5.4b2850ee.1804289383@sybase.com
From: Neil
Newsgroups: sybase.public.powerbuilder.objects
Subject: Re: Dropdown DW
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4b29fa53.48da.1681692777@sybase.com>
References: <4b29f9eb.48ca.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 17 Dec 2009 01:30:59 -0800
X-Trace: forums-1-dub 1261042259 10.22.241.41 (17 Dec 2009 01:30:59 -0800)
X-Original-Trace: 17 Dec 2009 01:30:59 -0800, 10.22.241.41
Lines: 16
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.objects:9958
Article PK: 737087

I forgot to mention, I am using PB 10.2.1 Build 9948.

> Hi All, I have a problem with Dropdown DW. Example, this
> is the list in the DDDW.
> Code Description
> 1 ABC
> 2 ABC
>
> I can't select the code 2, it will always return code 1,
> even when I select the second line in the list which
> supposedly should return the code 2.
>
> What is the workaround on this?
>
> Thanks,
> Neil


Ivaylo Ivanov Posted on 2009-12-17 11:47:21.0Z
From: "Ivaylo Ivanov" <n0_S_p_a_m_i.ivanov@isy-dc.com>
Newsgroups: sybase.public.powerbuilder.objects
References: <4b29f9eb.48ca.1681692777@sybase.com> <4b29fa53.48da.1681692777@sybase.com>
Subject: Re: Dropdown DW
Lines: 43
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
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: <4b2a1a49$1@forums-1-dub>
Date: 17 Dec 2009 03:47:21 -0800
X-Trace: forums-1-dub 1261050441 10.22.241.152 (17 Dec 2009 03:47:21 -0800)
X-Original-Trace: 17 Dec 2009 03:47:21 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.objects:9959
Article PK: 737088

This is the default behavior of the DDDWs when you have a non-unique display
values.

Workaround - try to make the display values unique.
First option: add unique index upon your description column and push the
users to enter unique nomenclature texts
Second option: add a computed field with expression which makes it unique
and use this computed field as a Display Column of the DDDW instead of your
Description column (hide it in the dropdown):

descr_column + space(100) + fill("_", getrow())

or

descr_column + space(100) + fill("_", code_column)

This way, using space(...) makes the unique garbage part (underscore
character repeated unique number of times) to be displayed at the very right
of the cell, so if your dropdown width is set to 100%, the user won't see
this garbage at all.

Regards,
Ivaylo

<Neil> wrote in message news:4b29fa53.48da.1681692777@sybase.com...
>I forgot to mention, I am using PB 10.2.1 Build 9948.
>
>> Hi All, I have a problem with Dropdown DW. Example, this
>> is the list in the DDDW.
>> Code Description
>> 1 ABC
>> 2 ABC
>>
>> I can't select the code 2, it will always return code 1,
>> even when I select the second line in the list which
>> supposedly should return the code 2.
>>
>> What is the workaround on this?
>>
>> Thanks,
>> Neil


Ivaylo Ivanov Posted on 2009-12-17 11:49:40.0Z
From: "Ivaylo Ivanov" <n0_S_p_a_m_i.ivanov@isy-dc.com>
Newsgroups: sybase.public.powerbuilder.objects
References: <4b29f9eb.48ca.1681692777@sybase.com> <4b29fa53.48da.1681692777@sybase.com> <4b2a1a49$1@forums-1-dub>
Subject: Re: Dropdown DW
Lines: 50
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
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: <4b2a1ad4$1@forums-1-dub>
Date: 17 Dec 2009 03:49:40 -0800
X-Trace: forums-1-dub 1261050580 10.22.241.152 (17 Dec 2009 03:49:40 -0800)
X-Original-Trace: 17 Dec 2009 03:49:40 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.objects:9960
Article PK: 737089

Note that adding just unique number of spaces to the description won't do
the trick!

"Ivaylo Ivanov" <n0_S_p_a_m_i.ivanov@isy-dc.com> wrote in message
news:4b2a1a49$1@forums-1-dub...
> This is the default behavior of the DDDWs when you have a non-unique
> display values.
>
> Workaround - try to make the display values unique.
> First option: add unique index upon your description column and push the
> users to enter unique nomenclature texts
> Second option: add a computed field with expression which makes it unique
> and use this computed field as a Display Column of the DDDW instead of
> your Description column (hide it in the dropdown):
>
> descr_column + space(100) + fill("_", getrow())
>
> or
>
> descr_column + space(100) + fill("_", code_column)
>
> This way, using space(...) makes the unique garbage part (underscore
> character repeated unique number of times) to be displayed at the very
> right of the cell, so if your dropdown width is set to 100%, the user
> won't see this garbage at all.
>
> Regards,
> Ivaylo
>
> <Neil> wrote in message news:4b29fa53.48da.1681692777@sybase.com...
>>I forgot to mention, I am using PB 10.2.1 Build 9948.
>>
>>> Hi All, I have a problem with Dropdown DW. Example, this
>>> is the list in the DDDW.
>>> Code Description
>>> 1 ABC
>>> 2 ABC
>>>
>>> I can't select the code 2, it will always return code 1,
>>> even when I select the second line in the list which
>>> supposedly should return the code 2.
>>>
>>> What is the workaround on this?
>>>
>>> Thanks,
>>> Neil
>
>