nagu
|
| Posted: 02/24/2002, 12:29 PM |
|
I am newbie to Codecharge. I am building a Record page where I have to edit a flag - the flag is actually stored in the db in three flags. For example, there are three columns : use_A_flag, use_B_flag and use_Both_flag
Is it possible to populate the three flags with one radiolist or listbox?
Or if I use checkbox, they should be exclusive(checking one should uncheck the others in the set)
So can anyone suggest the code to do the above. I am generating ASP.
thanks,
nagu
|
|
|
 |
Nicole
|
| Posted: 02/25/2002, 6:11 AM |
|
Nagu,
you may use radio button field for 3 existing fields. Add all of them to the form and set their types to Hidden. The specify custom list of values for radio button field:
1;"&fldfield1&";2;"&fldfield2&"
|
|
|
|
nagu
|
| Posted: 02/25/2002, 8:16 AM |
|
Thanks for your response. I tried adding the three fields as hidden to the form.
When I tried 1;"&fldfield1&";2;"&fldfield2&" format, the screen showed the values.
Since I thought it is value;"screen text" format, I tried this format:
"&fldfield1&";Option One;"&fldfield2&";Option two;"&fldfield3&";Option three
The database columns are not updated when I click on the update. Is there anything more I need to do to update the field(any code in events to update the columns?). I thought the use of columns in the customized value would be enough to update the DB and fetch the values from the DB. Please let me know if I need to put sql queries for fetching the values to display the record in the screen.
thanks,
Nagu
|
|
|
|
CodeCharge Support
|
| Posted: 02/26/2002, 12:04 AM |
|
Nagu,
If you have assigned RadioButton field to any table field, it should be included to insert and update sql statements. Otherwise you should create Custom Action event and include field with corresponding value to sql statements. Take a look at generated code and check it.
|
|
|
|
|
