Using FORMS_DDL to upadate another table
748145Nov 8 2010 — edited Nov 8 2010Hi All,
I wants to update a record of a table using forms_ddl statement against a button from a form based on another table. I used the following code to do this but no update or no error
occered--
COMMIT_FORM;
IF :CASE_STATUS.WRIT_OFF=1 THEN
FORMS_DDL('UPDATE CASE_INFO SET WRIT_OFF=1 WHEN CASE_NO= '||:CASE_STATUS.CASE_NO);
ELSE
FORMS_DDL('UPDATE CASE_INFO SET WRIT_OFF=0 WHEN CASE_NO= '||:CASE_STATUS.CASE_NO);
END IF;
COMMIT_FORM;
What is the wrong with my code. Please help me to find out the issue. I am using forms 10g.
Arif