1Z0-151 · Question #36
You do not want users to execute queries while in the Order_Items block, so you write the following key-Exeqry trigger for the Order_Items block: GO_BLOCK('orders'); EXECUTE_QUERY; This works fine…
The correct answer is C. Delete the Key-Exqry trigger and define the following Key-Entqry trigger for the Order_Items block. Note: You can use system variables and built-ins to obtain information about queries. Using SYSTEM.mode Use the SYSTEM.mode system variable to obtain the form mode. The three values are NORMAL , ENTER_QUERY , and QUERY. NORMAL Indicates that the form is currently in normal…
Question
You do not want users to execute queries while in the Order_Items block, so you write the following key-Exeqry trigger for the Order_Items block:
GO_BLOCK('orders'); EXECUTE_QUERY; This works fine except that in the Order_Items block, when you click Enter Query first, and then click Execute Query, you get the error message "FRM-41009: Function key not allowed." What can you do correct this?
Options
- ASet the Fire in Enter-Query Mode property of the Key-Exeqry trigger to Yes.
- BAdd the following as the first of the key-Exqry trigger to Yes.
- CDelete the Key-Exqry trigger and define the following Key-Entqry trigger for the Order_Items block:
- DDelete the Key-Exqry trigger and define the following Key-Entqry trigger for the Order_Items block:
- EChange the key-Exqry trigger to:
- FChange the Key-Exeqry trigger to:
- GYou cannot change this behavior, but you should use the On-Message trigger to display a more meaningful
How the community answered
(23 responses)- B4% (1)
- C78% (18)
- D4% (1)
- F13% (3)
Explanation
Note: You can use system variables and built-ins to obtain information about queries. Using SYSTEM.mode Use the SYSTEM.mode system variable to obtain the form mode. The three values are NORMAL , ENTER_QUERY , and QUERY. NORMAL Indicates that the form is currently in normal processing mode. ENTER-QUERY Indicates that the form is currently in Enter Query mode. QUERY Indicates that the form is currently in fetch processing mode, meaning that a query is currently being processed. Note 1: ENTER_QUERY procedure Clears the current block and creates a sample record. Operators can then specify query conditions before executing the query with a menu or button command.If there are changes to commit, the Forms Builder prompts the operator to commit them before continuing ENTER- QUERY processing Note 2: EXECUTE_QUERY procedure Clears the current block, opens a query, and fetches anumber of selected records. If there are changes tocommit, Forms Builder prompts the operator to committhem before continuing EXECUTE-QUERYprocessin
Topics
Community Discussion
No community discussion yet for this question.