Re: How do you do this with a checkbox???

The trigger should work, but you will need to force the user to navigate thru all 4 boxes prior to the trigger being fired to be sure all choices are concatenated - you might consider separating the choices with a delimiter so you can search the field later for specific entries ( if you use a separate delimiter for each value, you can quickly check for a particular check box - for instance:
set check_result =
'#'||box1||'#'||'_at_'||box2||'@'||'!'||box3||'!'||'~'||box4||'~'

will let you find records where box3 was not checked with: select * from table where check_result like '%'!!'%';

Just an approach...

Richard Hollingsworth <william.hollingsworth_at_hsv.boeing.com> wrote:

>Hi folks. Thanks for reading this.
>
>I have an 8.0.5 database and I'm using Forms 2.1.
>
>I have a field in the db called "EFFECT_ON" which is a varchar2(10)
>filed.
>
>On my form, I wnat 4 checkboxes....1. Hardware, 2. Software, 3.
>Documentation, 4. Other.
>
>Rather than having 4 seperate fields in the db, I want just one.
>
>How do I get multiple values stuffed into this one field in the db?
>
>Can you group checkboxes like you can radio buttons?
>
>How about using a trigger that fires when you complete checking boxes
>that will use a select into statement that concatenates all four
>checkboxes and places that into the db field?
>
>Any ideas on how to do this will be greatly appreciated.
>
>Thanks,
>
>Richard Hollingsworth

[Quoted]   -----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------    http://www.newsfeeds.com The Largest Usenet Servers in the World! [Quoted] ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==----- Received on Mon Feb 07 2000 - 19:44:06 CET