Boolean Variables
Boolean variables generate code based on whether or not the frame functions in a specific way; for example, whether user qualifications are allowed on an Update frame. The following variables are set to either "0" (false) or "1" (true) before the code is generated. Most of these variables are set in the Visual Query and by frame behaviors. You can use these variables in ##if or ##ifdef statements.
$dbevent_code_exists
Specifies the frame contains On-Dbevent escape code
$default_start_frame
Specifies the default start-up frame for the application
$delete_allowed
(Update frames only) Specifies that deletes are allowed on either the Master or Detail table
$delete_cascades
Specifies that corresponding Detail table records must be deleted when a Master table record is deleted
$delete_dbmsrule
Specifies that when a user selects Delete on an Update frame with a Master and Detail table, the generated code deletes only the Master table row and allows the DBMS to delete the corresponding Detail table records
The default value is FALSE.
$delete_detail_allowed
(Update frames only) Specifies that detail table deletes are allowed
$delete_master_allowed
(Update frames only) Specifies that Master table deletes are allowed
$delete_restricted
(Update frames only) Specifies that Master table deletes are prohibited when corresponding Detail table rows exist
$insert_detail_allowed
(Update frames only) Specifies that detail table insertions are allowed
$insert_master_allowed
(Update frames only) Specifies that new Master table rows can be appended; causes an AddNew and AppendMode menu item to be generated
$join_field_displayed
Specifies that any of the join fields are displayed (used with the Update Cascades integrity rule for Update frames with Master and Detail tables)
$join_field_used
Specifies that any of the join fields are used on the form or in variables
$lookup_exists
Specifies that a Lookup table is included in the Visual Query
$master_in_tblfld
Specifies that the Master table is displayed as a table field (always false for a frame with a Detail table)
$master_seqfld_exists
Specifies that a sequenced field is specified for the Master table on an Append frame
$master_seqfld_displayed
Specifies that a sequenced field for the Master table on an Append frame is displayed on the form
$master_seqfld_used
Specifies that a sequenced field for the Master table on an Append frame is used on the form or in a variable
$nullable_master_key
(Update frames only) Specifies that any column of the Master table key is nullable
$nullable_detail_key
(Update frames only) Specifies that any column of the Detail table key is nullable
$singleton_select
Specifies that only one Master table row must be retrieved (no Next menu item is to be generated)
$tablefield_menu
Specifies that the menu items on a Menu frame are displayed as a table field
$timeout_code_exists
Specifies that the frame contains On-Timeout escape code
$update_cascades
(Update frames with Master and Detail tables) Specifies that corresponding Detail table records must be updated when a value in a join field is changed
$update_dbmsrule
Specifies that when a user selects Save on an Update frame, the generated code does not update the join fields in the Detail table, but rather allows the DBMS to apply those updates, based on changes to the corresponding columns of the Master table
$update_restricted
Specifies that the value of the join columns in a Master table record cannot be updated if corresponding Detail table records exist
$user_qualified_query
Specifies that users can enter runtime query qualifications on a Browse or Update frame