switbeck wrote:Set the item properties Source Type to Database Column and Source value or expression to the name of the column (note that contrary to normal Oracle practice the column name is case sensitive).
Hmm, I figured out how to add the item to the form and when I run the form to add the row it adds the row but the field that I added does not get added to the report.
the column name is case sensitiveYou can see this in the Help of Source Type:
switbeck wrote:Do not include the table name. Unless the column was created using the quoted identifier <tt>"Requester"</tt>, set Source value or expression to <tt>REQUESTER</tt>.
Now I get this error:
ORA-06550: line 1, column 205: PL/SQL: ORA-00904: "INITIATE.Requester": invalid identifier ORA-06550: line 1, column 13: PL/SQL: SQL Statement ignored
INITIATE.Requester is the table and column.