Updating a data block's default query in Oracle Forms
Posted on 2012-03-29
I am trying to edit an Oracle Form. I am using Oracle Form Builder v. 5, with Oracle 8. I removed a column of a table in the database. I went into the Form and used the Data Block Wizard to refresh the table items. I removed the code from the Triggers that referenced that field of the table. But when I run the form, I am getting an error "unable to perform query' and when I look at the Error, it shows the query is still requesting that field of the table. In the WHEN-NEW-FORM-INSTANCE, this is the code:
where_clause := 'rec_id = '||''''|| :parameter.record_id ||'''';
Set_Block_property(block_id, default_where, where_clause);
Where is it getting the query? Why does the query still show the field that I removed? How can I update the default query?