Re: FORMS 4.5 - Multiple Selections

From: Neville Sweet <sweet.neville.nj_at_bhp.com.au.no_junk_today_thanks>
Date: 1998/02/23
Message-ID: <01bd4013$ca8aeb20$45f11286_at_itwol-pc3963.itwol.bhp.com.au>#1/1


Hi Ariel,

Since you haven't been flooded with suggestions it would appear there is no easy answer.
You could however force the Form to behave in the way you describe.

Create a non-display item and a block-level When-Mouse-Click trigger. The non-display item is just a flag to be toggled as the user selects and de-selects rows. Selections can be indicated by setting each item's visual attributes in the selected record -- take a look at 'Display_Item'. When the user hits the Delete button, do a First_Record and loop through all rows (Next_Record), issuing a delete on each row selected. The variable System.Mouse_Button_Shift_State indicates that the Ctrl key is pressed.

Some associated issues come to mind, eg. effect of Current Record highlight (if used), location of cursor after deletions completed, effect of Click without Ctrl being pressed.

It also seems to me that since you are providing Ctrl-Click functionality then you should also be offering Shift-Click range selection. There is an easy answer for that one -- a "Range selection not available" message. Then again, if you've gone this far...

Ariel Kirson <arielk_at_exlibris.co.il> wrote in article <34EC6453.A40FBEA4_at_exlibris.co.il>...
> Hi Oracle Forms 4.5 users,
>
> Is there some way of selecting multiple records
> from a table in oracle forms 4.5 ?
>
> i.e.
> to select several
> records by cntrl+clicking - and then pressing a delete
> button to delete them all.
>
> Patiently awaiting your advice,
>
> Ariel Kirson
> Ex Libris.
>
>
>
Received on Mon Feb 23 1998 - 00:00:00 CET

Original text of this message