The DBA informed you that a number column called ORDER_STATUS has been added to the ORDERS table.
The DBA ran a SQL script to populate that column.
You want to update the Orders form to display the additional data. You currently have a non-base-table display item in the Orders block called Order_Total that you no longer want to use. The Order_Total item is located on the canvas in the position where you want the Order_Status item to appear. You open the Property Palette for Order_Total, change its name to Order_Staus, and change its item type to Text Item. You run the form, but when you execute a query on the block, no data is displayed in the Order_Status item.
What should you do to correct this problem?
A.
Set the Database Item property to Yes for the Order_Status item.
B.
Use the form to populate the Order_Status item, since the SQL script that the DBA ran obviously did not work.
C.
Set the Name property for the Order_Status item to ORDER_STATUS, because it must be uppercase to match the column name in the database.
D.
Use the Data Block Wizard in reentrant mode to add the item, because you cannot add a base table item by changing the item type of an existing item.