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.

Changing selected row indicator on grid datawindow

4 posts in DataWindow Last posting was on 2008-11-11 13:00:49.0Z
Karen Posted on 2008-11-10 21:39:09.0Z
Sender: 4d78.4918a8d3.1804289383@sybase.com
From: Karen
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Changing selected row indicator on grid datawindow
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4918a9fd.4d92.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 10 Nov 2008 13:39:09 -0800
X-Trace: forums-1-dub 1226353149 10.22.241.41 (10 Nov 2008 13:39:09 -0800)
X-Original-Trace: 10 Nov 2008 13:39:09 -0800, 10.22.241.41
Lines: 20
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88148
Article PK: 417402

Hi,

I need to modify the background colour of a column to
identify if it is ready to accept data from an instrument in
a datawindow and have run into a problem. I set the
background.color property for the column, but the selected
row is highlighted hiding the colour change. The colour of
the column is not visible until i select a different row.

Is there a way to change the identifier for the currently
selected row from a solid blue band to a dotted line around
the row or something similar? I need some other way of
identifying the selected row that would display the
background colour of columns.

I am using Powerbuilder 11.1 Build 8204

Thanks,

Karen


Paul Horan[Sybase] Posted on 2008-11-10 22:53:49.0Z
From: "Paul Horan[Sybase]" <phoran_nospam@sybase.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4918a9fd.4d92.1681692777@sybase.com>
Subject: Re: Changing selected row indicator on grid datawindow
Lines: 38
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-RFC2646: Format=Flowed; Original
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: <4918bb7d@forums-1-dub>
Date: 10 Nov 2008 14:53:49 -0800
X-Trace: forums-1-dub 1226357629 10.22.241.152 (10 Nov 2008 14:53:49 -0800)
X-Original-Trace: 10 Nov 2008 14:53:49 -0800, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88149
Article PK: 417403

One technique I've used is to add a dummy numeric column to the SQL of the
datawindow.

0 as isSelected,

Then instead of using SelectRow( row ), you can do a SetItem( row,
"isSelected", 1 ). 1 means selected, 0 means unselected.
With that as a foundation, you can do whatever you'd like in with the
graphics by using an expression based on the "isSelected" column.
I like placing a .bmp of an right arrow just to the left of the first
column, then setting its .Visible property to "isSelected".

Paul Horan[TeamSybase]

<Karen> wrote in message news:4918a9fd.4d92.1681692777@sybase.com...
> Hi,
>
> I need to modify the background colour of a column to
> identify if it is ready to accept data from an instrument in
> a datawindow and have run into a problem. I set the
> background.color property for the column, but the selected
> row is highlighted hiding the colour change. The colour of
> the column is not visible until i select a different row.
>
> Is there a way to change the identifier for the currently
> selected row from a solid blue band to a dotted line around
> the row or something similar? I need some other way of
> identifying the selected row that would display the
> background colour of columns.
>
> I am using Powerbuilder 11.1 Build 8204
>
> Thanks,
>
> Karen


"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel Posted on 2008-11-10 23:30:55.0Z
From: "Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4918a9fd.4d92.1681692777@sybase.com>
Subject: Re: Changing selected row indicator on grid datawindow
Lines: 28
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-RFC2646: Format=Flowed; Original
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: <4918c42f$1@forums-1-dub>
Date: 10 Nov 2008 15:30:55 -0800
X-Trace: forums-1-dub 1226359855 10.22.241.152 (10 Nov 2008 15:30:55 -0800)
X-Original-Trace: 10 Nov 2008 15:30:55 -0800, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88150
Article PK: 417404

The selected highlighting is a windows property, so use something like Paul
suggested instead of SelectRow.
For a line around the row, a rectangle object with a transparent fill sounds
like what you need.

<Karen> wrote in message news:4918a9fd.4d92.1681692777@sybase.com...
> Hi,
>
> I need to modify the background colour of a column to
> identify if it is ready to accept data from an instrument in
> a datawindow and have run into a problem. I set the
> background.color property for the column, but the selected
> row is highlighted hiding the colour change. The colour of
> the column is not visible until i select a different row.
>
> Is there a way to change the identifier for the currently
> selected row from a solid blue band to a dotted line around
> the row or something similar? I need some other way of
> identifying the selected row that would display the
> background colour of columns.
>
> I am using Powerbuilder 11.1 Build 8204
>
> Thanks,
>
> Karen


Karen Posted on 2008-11-11 13:00:49.0Z
Sender: 4d78.4918a8d3.1804289383@sybase.com
From: Karen
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Changing selected row indicator on grid datawindow
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <49198201.6110.1681692777@sybase.com>
References: <4918c42f$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 11 Nov 2008 05:00:49 -0800
X-Trace: forums-1-dub 1226408449 10.22.241.41 (11 Nov 2008 05:00:49 -0800)
X-Original-Trace: 11 Nov 2008 05:00:49 -0800, 10.22.241.41
Lines: 32
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88154
Article PK: 417409

Thanks alot guys for the quick responses.

Karen

> The selected highlighting is a windows property, so use
> something like Paul suggested instead of SelectRow.
> For a line around the row, a rectangle object with a
> transparent fill sounds like what you need.
>
> <Karen> wrote in message
> > news:4918a9fd.4d92.1681692777@sybase.com... Hi,
> >
> > I need to modify the background colour of a column to
> > identify if it is ready to accept data from an
> > instrument in a datawindow and have run into a problem.
> > I set the background.color property for the column, but
> > the selected row is highlighted hiding the colour
> > change. The colour of the column is not visible until i
> select a different row. >
> > Is there a way to change the identifier for the
> > currently selected row from a solid blue band to a
> > dotted line around the row or something similar? I need
> > some other way of identifying the selected row that
> > would display the background colour of columns.
> >
> > I am using Powerbuilder 11.1 Build 8204
> >
> > Thanks,
> >
> > Karen
>
>