How i can set checkedvalue or uncheckedvalue for checkbox component inside pl/sql? |
Hi Lezgin, As i understand you have a grid based on a view. Inside the grid is a checkbox. If you check the checkbox the row must be deleted, and if you uncheck, the row must be saved. I would do the following: Create the view including the checkbox column (wich would be null for all rows) Define the datasource on the view, and specify the primary key, so you can check insert, update and/or delete. Create the grid with the checkbox and define the checkbox values like:
Create an instead of trigger on the view. In this instead of trigger, catch the condition of the checkbox and save, or remove according to the checkbox value set. Something like this:
After saving the grid with Should work i think.. Best , Michiel A Hi Michiel . Ugur helped me to fix this problem. Your solution is like Ugur solution
(02 Nov '12, 12:41)
lezgin
|
Hi Zamir, There isn't an API setting the checkedValue/unchekedValue of the checkBox. If you need such an API, we can add it among the candidate features to be included to the future releases. Regards, Ibrahim I wanna save data if checkbox was checked and remove daa from table if checkbox unchecked. How i can do it?
(02 Nov '12, 03:34)
lezgin
checkbox must be inside GRID.
(02 Nov '12, 03:34)
lezgin
Hi Zamir, If the checkBox is inside of a grid, a datasource column should be already bound to this checkBox. Therefore, you can retrieve its value through the api_datasource.getColumnValue API. Regards, Ibrahim
(02 Nov '12, 04:00)
Ibrahim Sand... ♦♦
i replaced query with view. but still i can't set data to table. ((
(02 Nov '12, 04:29)
lezgin
|