I am trying to add a checkbox item as database item , and when I check it e.g , that value should be saved in the database .
It's not working . I check it but in the database , the value remains unchanged . Any help please ? Thanks.
Assuming that its datatype is character , name is selected
Pls Change properties of the check box item as below NAME SELECTED
*Item Type* Check Box
*Value when Checked* Y Value when Unchecked N
*Check Box Mapping of Other Values* Not Allowed
*Initial Value* N
*Database Item* yes column name is: ur Db Column name.
Do u have any db triggers , functions,etc.
Do u have any key commit or related triggers ?
Do u have triggers related insert or update functionality which alll might affect the process of insert or updates.?
To save the value of a CheckBox to a database table, your CheckBox item should be a Base Table Item. Your CheckBox Item type should match your table's column data type. For example, if your CheckBox's Check value is 'Y' and Unchecked value is 'N' then your table's column data type should CHAR(1) or VARCHAR2(1). Also, set the Check Box Mapping of Other Values to Not Allowed if your CheckBox will only be Y or N. Now, when you save your Form, the value of the CheckBox will automatically be saved to your table.
Can you please clarify what you mean by this please ?
You have updated the On-insert and/or On-update triggers with the insert and/or update statements accordingly?>
My guess is that 987583 is referring to if your CheckBox is NOT a base table item, then you would need to use the On-Insert and On-Update triggers to update your database table correctly.
It is always best to base your Block objects on Table objects. Then Forms will do most of the work for you so you don't have to write code to perform DML.
Hope this helps.