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.

Picture-Control

3 posts in DataWindow Last posting was on 2009-02-17 17:55:06.0Z
Bart Posted on 2009-02-17 16:05:56.0Z
Sender: 16b7.49997f98.1804289383@sybase.com
From: Bart
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Picture-Control
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <499ae064.3272.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 17 Feb 2009 08:05:56 -0800
X-Trace: forums-1-dub 1234886756 10.22.241.41 (17 Feb 2009 08:05:56 -0800)
X-Original-Trace: 17 Feb 2009 08:05:56 -0800, 10.22.241.41
Lines: 7
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88808
Article PK: 418061

Hi,
I have a datawindow.
What is the best way, if I retrieve data in a datawindow
that based on the value of a column a specific picture show
or another picture. For example when the value is "Y" Then a
Yes picture is showed on the row ... when it is a "N" then a
No picture is showed.


"Jason 'Bug' Fenter [TeamSybase]" <NO_SPAMMING_jason.fenter_ Posted on 2009-02-17 16:26:00.0Z
From: "Jason 'Bug' Fenter [TeamSybase]" <NO_SPAMMING_jason.fenter_@_teamsybase.com>
User-Agent: Thunderbird 2.0.0.19 (Windows/20081209)
MIME-Version: 1.0
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Picture-Control
References: <499ae064.3272.1681692777@sybase.com>
In-Reply-To: <499ae064.3272.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: <499ae518$1@forums-1-dub>
Date: 17 Feb 2009 08:26:00 -0800
X-Trace: forums-1-dub 1234887960 10.22.241.152 (17 Feb 2009 08:26:00 -0800)
X-Original-Trace: 17 Feb 2009 08:26:00 -0800, vip152.sybase.com
Lines: 14
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88809
Article PK: 418062

There are many ways. If it were me, here's what I would do. Have two
picture controls, one of each appropriate picture. Make them the same
size and put them in the same position. Use expressions to toggle the
visibility of each appropriately.

Bart wrote:
> Hi,
> I have a datawindow.
> What is the best way, if I retrieve data in a datawindow
> that based on the value of a column a specific picture show
> or another picture. For example when the value is "Y" Then a
> Yes picture is showed on the row ... when it is a "N" then a
> No picture is showed.


"Paul Horan[Sybase]" <phoran_remove Posted on 2009-02-17 17:55:06.0Z
From: "Paul Horan[Sybase]" <phoran_remove@remove_sybase.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <499ae064.3272.1681692777@sybase.com> <499ae518$1@forums-1-dub>
Subject: Re: Picture-Control
Lines: 27
Organization: Sybase
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: <499af9fa@forums-1-dub>
Date: 17 Feb 2009 09:55:06 -0800
X-Trace: forums-1-dub 1234893306 10.22.241.152 (17 Feb 2009 09:55:06 -0800)
X-Original-Trace: 17 Feb 2009 09:55:06 -0800, vip152.sybase.com
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88810
Article PK: 418063

Create a computed column with the following expression:

bitmap((if Y_N_col = 'Y', 'yes.bmp', 'no.bmp' ))

--
Paul Horan[Sybase]
paulhoran.pbdjmagazine.com

"Jason 'Bug' Fenter [TeamSybase]"

<NO_SPAMMING_jason.fenter_@_teamsybase.com> wrote in message
news:499ae518$1@forums-1-dub...
> There are many ways. If it were me, here's what I would do. Have two
> picture controls, one of each appropriate picture. Make them the same size
> and put them in the same position. Use expressions to toggle the
> visibility of each appropriately.
>
>
> Bart wrote:
>> Hi,
>> I have a datawindow.
>> What is the best way, if I retrieve data in a datawindow
>> that based on the value of a column a specific picture show
>> or another picture. For example when the value is "Y" Then a
>> Yes picture is showed on the row ... when it is a "N" then a
>> No picture is showed.