This content has been marked as final. Show 7 replies
Assuming that its datatype is character , name is selected
Pls Change properties of the check box item as below
*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.
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.