Datawindow Row Selection and Protected Columns

[Glenda Kline]

From: "Glenda Kline" <gkl...@rejis.org>
Subject: Datawindow Row Selection and protected columns
Date: Tuesday, January 27, 2004 9:17 AM

This is an old problem. I searched the PB newsgroups to find an answer, but
didn't have much success. . .

I am using the PFC datawindow row selection service (extended). I want the
user to be able to select multiple rows to perform deletes, printing, etc.
I also want to allow the user the capability to edit certain rows (based on
business rules). The row selection service works correctly as long as none
of the rows in the datawindow are editable. Once there is an editable
column/row, the user can't click on the protected rows. Is there a
work-around to this problem? Please don't tell me to include a small
editable column on each row. This is not a very good solution as the user
then has to click on that one column in order for the row to be selected.

Any help would be greatly appreciated!

GKline

[dawn_t_brown_eyes[teamsybase]]

What I have done is to add a dummy field called checked in
the sql. ex: Select lastname, 0 as checked, ... from
table...
Then make this field a checkbox and have them select
the rows for deletion... by checking the check box.
I also have a running counter so they know how many rows
they
have checked (in the header: sum(checked))

It looks alot better than highlighting the rows, and it
seems to be more of a windows standard.

[Paul Horan[TeamSybase]]

Combine that technique with this one, and you get cool rowselection as well:

- Create a rectangle object. No border, and pick a color like "Mint" or something.
- Place that in the detail band, and size it from one end of the row to the other.
- Set the visible attribute to be simply: CHECKED. 1 means visible, 0 means invisible.
- Set the width attribute to be: long( describe( 'lastColumn.X')) + long( describe( 'lastColumn.width')) where
lastColumn is the farthest column to the right. That makes sure that the rectangle always covers the entire row.
- Right click on it, and select "Send to Back".
- Make sure the background color of all the columns is set to Transparent.

Now, whenever a row is "selected" with the checkbox, you'll get a nice Mint-green selection highlight behind it.

--
Paul Horan[TeamSybase]

<Dawn T Brown Eyes[TeamSybase]> wrote in message news:4016d102.41...@sybase.com...

[Glenda Kline]

Thanks for your help! I'll give these suggestions a try.
Glenda

"Paul Horan[TeamSybase]" <paulhATvcisolutionsDOTcom> wrote in message
news:4016e7e5$1@forums-1-dub...