3 Replies Latest reply: Dec 23, 2013 9:20 AM by CraigB RSS

    Change Canvas Name of a field dynamically

    Chandan.Rattan

      Hi i want to know can we change a Canvas Name of a field dynamically ?

       

      My requirement is that  i have "Street Name"  fields in many forms. Now i need to introduce a button next to "Street Name" field so that if "Street Name" values are available in LOV, then user can click on the Button and it will go the Street Master. Now problem is that "Street Name" Field is available in many forms. It would be too difficult to create a each field in each form. So instead of it i want to do it dynamically. If we can change a Field's (Item) canvas name dynamically then i think we achieve it.

       

      Thanks

        • 1. Re: Change Canvas Name of a field dynamically
          AnnPricks E

          From my knowledge, we cant change a canvas name dynamically.. Below are the possible properties we can change. You can get these from forms online help

           


          property
              
              The property you want to set for the given item. Possible properties are:

          ALIGNMENT The text alignment (text and display items only). Valid values are ALIGNMENT_START, ALIGNMENT_END, ALIGNMENT_LEFT, ALIGNMENT_ CENTER, ALIGNMENT_RIGHT. See the Justification Property for more information.

          AUTO_HINT Determines if Oracle Forms will display help hints on the status line automatically when input focus is in the specified item. Valid values are PROPERTY_TRUE and PROPERTY_FALSE. See Display Hint Automatically Property.

          AUTO_SKIP Specifies whether the cursor should skip to the next item automatically when the end user enters the last character in a text item. Valid only for a text item. Valid values are PROPERTY_TRUE and PROPERTY_FALSE.

          BACKGROUND_COLOR The color of the object's background region. The property value is a reference to an RGB value such as r191g223b191.

          BORDER_BEVEL Specifies the item border bevel for the specified item instance. Valid values are RAISED, LOWERED, or PLAIN (unbeveled).

          Note: You cannot set BORDER_BEVEL if the item's Bevel property is set to None in Oracle Forms.

          CASE_INSENSITIVE_QUERY Specifies whether query conditions entered in the item should be case-sensitive. Valid values are PROPERTY_TRUE and PROPERTY_FALSE.

          CASE_RESTRICTION Specifies the case restriction applied to any text entered in the indicated text item. Valid values are UPPERCASE, LOWERCASE, or NONE.

          CONCEAL_DATA Specify the constant PROPERTY_TRUE if you want the item to remain blank or otherwise obscured when the end user enters a value. Specify the constant PROPERTY_FALSE if you want any value that is typed into the text item to be visible.

          CURRENT_RECORD_ATTRIBUTE Specifies VARCHAR2 name of the named visual attribute used when an item is part of the current record. If the named visual attribute does not exist, you will get an error message.

          CURRENT_ROW_BACKGROUND_COLOR The color of the current record's background region.

          CURRENT_ROW_FILL_PATTERN The pattern to be used for the current record's fill region. Patterns are rendered in the two colors specified by Background Color and Foreground Color.

          CURRENT_ROW_FONT_NAME The font family, or typeface, that should be used for text in the current record. The list of fonts available is system-dependent.

          CURRENT_ROW_FONT_SIZE The size of the font, specified in points.

          CURRENT_ROW_FONT_SPACING The width of the font, that is, the amount of space between characters (kerning).

          CURRENT_ROW_FONT_STYLE The style of the font.

          CURRENT_ROW_FONT_WEIGHT The weight of the font.

          CURRENT_ROW_FOREGROUND_COLOR The color of the current record's foreground region. For items, the Foreground Color attribute defines the color of text displayed in the item.

          DIRECTION Specifies the layout direction for bidirectional objects. Valid values are DIRECTION_DEFAULT, RIGHT_TO_LEFT, LEFT_TO_RIGHT.

          DISPLAYED Specifies whether the item will be displayed/enabled or hidden/disabled.

          ECHO Specifies whether characters an end user types into a text item should be visible. When Echo is false, the characters typed are hidden. Used for password protection. Valid values are PROPERTY_TRUE and PROPERTY_FALSE.

          ENABLED Specifies whether end users should be able to manipulate an item. Valid values are PROPERTY_TRUE and PROPERTY_FALSE.

          Note: Setting Enabled to false will cause other item property settings to change.

          FILL_PATTERN The pattern to be used for the object's fill region. Patterns are rendered in the two colors specified by Background Color and Foreground Color.

          FONT_NAME The font family, or typeface, that should be used for text in the object. The list of fonts available is system-dependent.

          FONT_SIZE The size of the font, specified in hundredths of a point (i.e., for a font size of 8 points, the value should be set to 800).

          FONT_SPACING The width of the font, that is, the amount of space between characters (kerning).

          FONT_STYLE The style of the font.

          FONT_WEIGHT The weight of the font.

          FOREGROUND_COLOR The color of the object's foreground region. For items, the Foreground Color attribute defines the color of text displayed in the item. The property value is a reference to an RGB value such as r191g223b191. Foreground color is always ignored for scrollbars.

          FORMAT_MASK Specifies the display format and input accepted for data in text items.

          HEIGHT Specifies the height of the item.

          HINT_TEXT Specifies the item-specific help text displayed on the message line at runtime. If the text specified is NULL, the original hint text, specified in Oracle Forms, will be restored.

          ICON_NAME Specifies the file name of the icon resource associated with a button item having the Iconic property set to YES.

          IMAGE_DEPTH Specifies the depth of color to be applied to an image item.

          INSERT_ALLOWED In a new record, allows end user to insert items normally when set to PROPERTY_TRUE. Specify PROPERTY_FALSE to specify that the item does not accept modification, but is displayed normally (not grayed out). (Insert_Allowed does not propagate changes to the Enabled property.)

          ITEM_IS_VALID Specifies whether the current item should be considered valid. Set to PROPERTY_TRUE or PROPERTY_FALSE.

          ITEM_SIZE Specifies a width and height for the item as two numbers separated by a comma. Use the syntax that includes x, y.

          KEEP_POSITION Specifies whether the Keep Cursor Position property should be true or false. When Keep Cursor Position is true, the cursor returns to the same position it was in when it left the text item. When Keep Cursor Position is false, the cursor returns to the default position in the text item. Valid values are PROPERTY_TRUE and PROPERTY_FALSE.

          LABEL Specifies the VARCHAR2 string that you want displayed as the label of the item. This property is only valid for items that have labels, such as buttons.

          LOCK_RECORD_ON_CHANGE Specify the constant PROPERTY_TRUE if you want the record to be locked when this item is changed. Specify the constant PROPERTY_FALSE if you do not want the record locked when this item is changed. Use primarily when connecting to a non-ORACLE data source that does not have row-level locking.

          LOV_NAME Specify the VARCHAR2 name of an LOV to be associated with the given item. If the LOV name does not exist, you will get an error message.
             

          MERGE_CURRENT_RECORD_ATTRIBUTE Merges the contents of the specified visual attribute with the current row's visual attribute (rather than replacing it).

          MERGE_TOOLTIP_ATTRIBUTE Merges the contents of the specified visual attribute with the tooltip's current visual attribute (rather than replacing it).
             

          MERGE_PROMPT_VISUAL_ATTRIBUTE Specifies the named visual attribute that should be applied to the prompt at runtime.
             

          MERGE_VISUAL_ATTRIBUTE Merges the contents of the specified visual attribute with the object's current visual attribute (rather than replacing it).

          MOUSE_NAVIGATE Specifies whether Oracle Forms should navigate and set focus to the item when the end user activates the item with the mouse. Specify the constant PROPERTY_TRUE if you want the end user to be able to navigate to the item using the mouse. Specify the constant PROPERTY_FALSE if you want a mouse click to keep the input focus in the current item.

          NAVIGABLE Specify the constant PROPERTY_TRUE if you want the end user to be able to navigate to the item using default keyboard navigation. Specify the constant PROPERTY_FALSE if you want to disable default keyboard navigation to the item. (Keyboard Navigable does not propagate changes to the Enabled property.)

          NEXT_NAVIGATION_ITEM Specifies the name of the item that is defined as the "next navigation item" with respect to this current item.

          POSITION Specify the x, y coordinates for the item as NUMBERs separated by a comma. Use the syntax that includes x, y.

          PREVIOUS_NAVIGATION_ITEM Specifies the name of the item that is defined as the "previous navigation item" with respect to this current item.

          PRIMARY_KEY Specify the constant PROPERTY_TRUE to indicate that any record inserted or updated in the block must have a unique characteristic in order to be committed to the database. Otherwise, specify the constant PROPERTY_FALSE.

          PROMPT_ALIGNMENT_OFFSET Determines the distance between the item and its prompt in the current record.

          PROMPT_DISPLAY_STYLE Determines the prompt's display style in the current record, either PROMPT_FIRST_RECORD, PROMPT_HIDDEN, or PROMPT_ALL_RECORDS.

          PROMPT_EDGE Determines which edge the item's prompt is attached to in the current record, either START_EDGE, END_EDGE, TOP_EDGE, or BOTTOM_EDGE.

          PROMPT_EDGE_ALIGNMENT Determines which edge the item's prompt is aligned to in the current record, either ALIGNMENT_START, ALIGNMENT_END, or ALIGNMENT_CENTER.

          PROMPT_EDGE_OFFSET Determines the distance between the item and its prompt in the current record as a VARCHAR2 value.

          PROMPT_FILL_PATTERN The pattern to be used for the prompt's fill region in the current record. Patterns are rendered in the two colors specified by Background Color and Foreground Color.

          PROMPT_FONT_NAME The font family, or typeface, that should be used for text in the prompt in the current record. The list of fonts available is system-dependent.

          PROMPT_FONT_SIZE The size of the font, specified in points in the current record.

          PROMPT_FONT_SPACING The width of the font, that is, the amount of space between characters (kerning) in the current record.

          PROMPT_FONT_STYLE The style of the font in the current record.

          PROMPT_FONT_WEIGHT The weight of the font in the current record.

          PROMPT_FOREGROUND_COLOR The color of the prompt's foreground region in the current record. For items, the Foreground Color attribute defines the color of text displayed in the item.

          PROMPT_TEXT Determines the text label that displays for an item in the current record.

          PROMPT_TEXT_ALIGNMENT Determines how the prompt is justified in the current record, either ALIGNMENT_START, ALIGNMENT_LEFT, ALIGNMENT_RIGHT, ALIGNMENT_CENTER, or ALIGNMENT_END.

          PROMPT_VISUAL_ATTRIBUTE Specifies the named visual attribute that should be applied to the prompt at runtime in the current record.

          QUERYABLE Specify the constant PROPERTY_TRUE if you want the end user to be able to initiate a query against the item. Specify the constant PROPERTY_FALSE if you want to disallow the use of the item in a query.

          QUERY_ONLY Specify an item to be queried, preventing that item from becoming part of insert or update statements. QUERY_ONLY is applicable to text items, radio groups, and check boxes. Enclose the fully-qualified item name in single quotes.

          REQUIRED Specify the constant PROPERTY_TRUE if you want to force the end user to enter a value for the item. Specify the constant PROPERTY_FALSE if the item is not to be required.
             

          TOOLTIP_BACKGROUND_COLOR The color of the tooltip's background region in the current record.

          TOOLTIP_FILL_PATTERN The pattern to be used for the tooltip's fill region in the current record. Patterns are rendered in the two colors specified by Background Color and Foreground Color.

          TOOLTIP_FONT_NAME The font family, or typeface, that should be used for text in the tooltip in the current record. The list of fonts available is system-dependent.

          TOOLTIP_FONT_SIZE The size of the font, specified in points of the tooltip in the current record.

          TOOLTIP_FONT_SPACING The width of the font, that is, the amount of space between characters (kerning) of the tooltip in the current record.

          TOOLTIP_FONT_STYLE The style of the font of the tooltip in the current record.

          TOOLTIP_FONT_WEIGHT The weight of the font of the tooltip in the current record.

          TOOLTIP_FOREGROUND_COLOR The color of the tooltip's foreground region in the current record. For items, the Foreground Color attribute defines the color of text displayed in the item.

          TOOLTIP_TEXT Determines the item's tooltip text in all records.

          UPDATE_ALLOWED Specify the constant PROPERTY_TRUE if you want the end user to be able to update the item. Specify the constant PROPERTY_FALSE if you want the item protected from update.

          UPDATE_COLUMN Specify the constant PROPERTY_TRUE if this column should be treated as updated, and included in the columns to be written to the database. Specify the constant PROPERTY_FALSE if this column should be treated as not updated, and not be included in the columns to be written to the database.

          UPDATE_NULL Specify the constant PROPERTY_TRUE if you want the end user to be able to update the item only if its value is NULL. Specify the constant PROPERTY_FALSE if you want the end user to be able to update the value of the item regardless of whether the value is NULL.

          UPDATE_PERMISSION Use UPDATE_ ALLOWED when you run against non-ORACLE data sources. Specify the constant PROPERTY_TRUE to turn on the item's UPDATEABLE and UPDATE_NULL properties. Specify the constant PROPERTY_FALSE to turn off the item's UPDATEABLE and UPDATE_NULL properties.

          VALIDATE_FROM_LIST Specifies that Oracle Forms should validate the value of the text item against the values in the attached LOV when set to PROPERTY_TRUE. Specify PROPERTY_FALSE to specify that Oracle Forms should not use the LOV for validation.

          VISIBLE Specifies whether the indicated item should be visible or hidden. Valid values are PROPERTY_TRUE and PROPERTY_FALSE.

          Note: Setting Visible to false will cause other item property settings to change.

          VISUAL_ATTRIBUTE Specify a valid named visual attribute that exists in the current form.

          Note: You cannot set the visual attribute for an image item, nor use a logical attribute from a resource
          file as a Visual Attribute.

          WIDTH Specify the width of the item as a NUMBER. The size of the units depends on how you set the Coordinate System property and default font scaling for the form.

          X_POS
             

          Specify the x coordinate as a NUMBER.
             

          Y_POS
              Specify the y coordinate as a NUMBER.

          • 2. Re: Change Canvas Name of a field dynamically
            HamidHelal

            First your requirement is not very clear.

            Secondly, which form version you are using, we don't know.

             

            Third, you cannot change the item name at run time.

             

            Hope this helps... hamid

            • 3. Re: Change Canvas Name of a field dynamically
              CraigB

              First, we need to know your Forms version (eg: 10.1.2, 11.1.2, etc).  Often times a solution is specific to your version.

              Second, it is not possible to dynamically change the canvas an item is assigned to.  Even if it were, you would still have to modify each form to implement this.  To me, a better solution would be to create a standard Address canvas and store it in an Object Library (.olb) then subclass this "Address" canvas in all of the forms that use it.  This enables you to make changes to the "Address" canvas and simply recompile your forms to implement the change rather than modify each form and compile.

               

              Craig...