Multiple choice

A number column called STATUS has been added to the ORDERS table. The SQL script was run to populate that column. The Orders form should be updated to display the additional data. Currently, there is a non-base table display item in the Orders block called Total that is no longer desired. The Total item is located on the canvas in the position where the Status item should appear. The Property Palette for Total was opened, its name was changed to Status, and its Item Type was changed to Text Item. The form was run, but when a query was executed on the block, no data was displayed in the Status item. What should be done to correct this problem?

  1. Set the Database Item property to Yes for the Status item.

  2. Use the form to populate the Status item, since the SQL script that was run obviously did not work.

  3. Set the Name property for the Status item to STATUS, because it must be uppercase to match the column name in the database.

  4. Use the Data Block Wizard in reentrant mode to add the item, because add a base table item cannot be added by changing the item type of an existing item.
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

When a non-base table item is renamed and changed to display a database column, you must explicitly set its Database Item property to Yes. This tells Forms that the item should map to a database column during query operations. The name case (uppercase STATUS) is not required for proper mapping.

Keep practicing — related questions