Lundi 30 décembre 1 30 /12 /Déc 11:46

 

Merry Christmas to everybody :)


This year, my present will be the Forms Resizer tool free for you!

You can use, play, modify and deploy it as you need and as you want. There is no license at all attached to it.

But, I won't continue to update, maintain it in any way, so there will not be any new version, any support, and I won't respond to any question about it.


Get the Forms Resizer tool for free there

Francois

Par Oracle Forms community - Publié dans : Bean - general
See the 0 comments
Mardi 7 mai 2 07 /05 /Mai 07:36

Purpose

Here is a Java Bean with a "breadcrumb" menu type behaviour
.


Conceal Text Field


The Java source

     BreadCrumb.java


The implementation class of the Java Bean

     oracle.forms.fd.BreadCrumb


The methods you can call



  • Set the background color

Set_Custom_Property( 'CTRL.BREADCRUMB', 1, 'SET_BACKGROUND', '#FFFFFF' );
 

  • Set the Font

Set_Custom_Property( 'CTRL.BREADCRUMB', 1, 'SET_FONT', 'Verdana,bold,14' );
 
second argument can be plain, bold, italic or bolditalic

 

 

  • Set the menu content

Set_Custom_Property( 'CTRL.BREADCRUMB', 1, 'SET_CONTENT', LC$Menu_Content );
 
declare
 s varchar2(2000);
begin 
 s := '<style>a.val {color: red}</style>';
 s := s || '<a class="val" href="module1.fmx">option 1</a>';
 s := s || ' >> <a class="val" href="module2.fmx">option 2</a>';
 s := s || ' >> option 3';
 Set_Custom_Property('CTRL.BREADCRUMB', 1, 'SET_LOG', 'true');
 Set_Custom_Property('CTRL.BREADCRUMB', 1, 'SET_BACKGROUND', '#FFFFFF');
 Set_Custom_Property('CTRL.BREADCRUMB', 1, 'SET_FONT', 'Verdana,bold,15');
 Set_Custom_Property('CTRL.BREADCRUMB', 1, 'SET_CONTENT', s);
end;

 

 

 

  • Set the log

Set_Custom_Property('BLOCK.TEXT_ITEM', 1, 'SET_LOG', 'true'); 

The event raised back to Forms

While the end-user selects an option, the LINK_ACTIVATED event is raised, then the link name is transmitted via the LINK_NAME parameter:

When-Custom-Item-Event trigger:

DECLARE
 
    eventName      varchar2(30) := :system.custom_item_event;
    eventValues    ParamList;
    eventValueType number;
    p1             varchar2(256);
 
BEGIN
 
   eventValues := get_parameter_list(:system.custom_item_event_parameters);
  
   IF (eventName='LINK_ACTIVATED') THEN  
      get_parameter_attr(eventValues,'LINK_NAME',eventValueType, p1);
      :CTRL.OPTION := p1;
      new_form(p1);
   END IF;
 
END;




The sample dialog

     .
  Download the breadcrumb.zip file
     .  Unzip the breadcrumb.zip file
     .  Copy the breadcrumb.jar file in your /forms/java/ folder
     .  Add it to the archive and archive_jini tags of the /forms/server/formsweb.cfg file
        e.g.: archive_jini=frmall_jinit.jar,breadcrumb.jar
                archive=frmall.jar,breadcrumb.jar
     . Open the breadcrumb.fmb module (Oracle Forms 10.1.2.0.2)
     . Compile all and run the module
 

Par Oracle Forms community - Publié dans : Bean - general
Send a comment - See the 0 comments
Mercredi 21 mars 3 21 /03 /Mars 18:38

This is another version of the Handle Image Java Bean. Is is based on the 3rd Bean version, with the following new features:

 

1. SETTOOLTIP() method to attach a tooltip to the Image Item


2. New Drag and Drop feature that allows the end user to drop an image file directly to the Image component.

 

An event is sent back to Forms to tell that the end user has changed the image content:

 

DECLARE 
    eventName varchar2(30) := :system.custom_item_event;
    eventValues ParamList;
    eventValueType number;
    p1  varchar2(256);
BEGIN
   eventValues := get_parameter_list(:system.custom_item_event_parameters);
  
   IF (eventName='IMAGE_DROPPED') THEN  
      get_parameter_attr(eventValues,'IMAGE_NAME',eventValueType, p1);
      Message('Image dropped:' || p1,no_acknowledge);      
   END IF;
END;


 

Get the new handleimage4.zip file


Par Oracle Forms community - Publié dans : Bean - general
Send a comment - See the 1 comments
Lundi 12 décembre 1 12 /12 /Déc 19:29

Purpose

Here is a PJC that hide parts of a text item
. It is usefull to hide the begin or the end (or any part actually) of a phone number or a credit card.


Conceal Text Field



The implementation class of the PJC

     oracle.forms.fd.ConcealTextField


The methods you can call



  • Set the bounds

Set_Custom_Property( 'BL.TI', 1, 'SET_BOUNDS', '1,6' );
 
This method indicates what part of the text you want to obfusk. In this example, we want to obfusk the first six charaters.

 

 

  • Set the log

Set_Custom_Property('BLOCK.TEXT_ITEM', 1, 'SET_LOG', 'true'); 



The sample dialog

     .
Download the concealtextfield.zip file
     .  Unzip the concealtextfield.zip.zip file
     .  Copy the concealtextfield.jar file in your /forms/java/ folder
     .  Add it to the archive and archive_jini tags of the /forms/server/formsweb.cfg file
        e.g.: archive_jini=frmall_jinit.jar,concealtextfield.jar
                archive=frmall.jar,concealtextfield.jar
     . Open the ConcealTextField.fmb module (Oracle Forms 10.1.2)
     . Compile all and run the module
 

Par Oracle Forms community - Publié dans : PJC - Text items
Send a comment - See the 0 comments
Samedi 27 août 6 27 /08 /Août 07:56

Purpose

Here is a Java Bean from Gert Poel, to Drop an external file within the Forms applications.




The Java source
 

     FileDrop.java   FileDropBean.java



The implementation class of the Java Bean


     oracle.forms.gp.FileDropBean


The event fired by the Java Bean


 DROP


The full filemane is transmitted in the EVENT_MSG parameter.

DECLARE
 l_eventName varchar2(30) := :system.custom_item_event;
 l_eventValues ParamList;
 l_eventValueType number;
 l_event_msg VARCHAR2(255);
BEGIN
   IF l_eventName = 'DROP'
   THEN
      l_eventValues := get_parameter_list(:system.custom_item_event_parameters);
      get_parameter_attr(l_eventValues,'EVENT_MSG',l_eventValueType, l_event_msg);
      IF :system.record_status <> 'NEW'
      THEN
         create_record;
      END IF;
      :ctrl.file_location := l_event_msg;
   END IF;
END;



The sample dialog

     .
Download the filedrop.zip file
     . Unzip the filedrop.zip file
     . Copy the FileDrop.jar file in your /forms/java/ folder
     . Add it to the archive and archive_jini tags of the /forms/server/formsweb.cfg file
     . Open the FILEDROP.fmb module (Oracle Forms 10.1.2)
     . Compile all and run the module

Par Oracle Forms community - Publié dans : Bean - general
Send a comment - See the 3 comments
Dimanche 26 juin 7 26 /06 /Juin 08:27

Purpose

Here is a Pluggable Java Component from Andreas Weiden, to have a "Card" item style within a single Text Item.

CardItem PJC



The Java source
 

     CardTextfield.java



The implementation class of the PJC (TextItem Item)


     forms.CardTextfield


The PJC initialisation


    
Read the content of the PK_CARDITEM package from the CARDITEM.fmb sample dialog





The sample dialog

     .
Download the carditem.zip file
     . Unzip the carditem.zip file
     . Copy the carditem.jar file in your /forms/java/ folder
     . Add it to the archive and archive_jini tags of the /forms/server/formsweb.cfg file
     . Compile the PKG_READ_BLOB_IMAGE.sql script in your database schema
     . Open the CARDITEM.fmb module (Oracle Forms 10.1.2.0.2)
     . Compile all and run the module

 

Par Oracle Forms community - Publié dans : PJC - Text items
Send a comment - See the 2 comments
Dimanche 3 avril 7 03 /04 /Avr 07:57

When you migrate to the latest Forms version (10.1.2.3 or 11) and try using a JavaBean created with an older Forms version, you can get the following error, at runtime, in the Java Console:

Exception in thread "thread applet-oracle.forms.engine.Main-1" java.lang.NoSuchMethodError: oracle.forms.handler.IHandler.getApplet()Ljava/applet/Applet

The reason is you try to use a Java Bean compiled with an older Forms JAR file, like f90all.jar.
So, to correct the issue, you have to change the Java code then re-create the JAR file:

private Main         formsMain = null;

Replace:

    formsMain  =  (Main) handler.getApplet();

by:

     // getting the Forms Main class
    try{
      Method method = handler.getClass()
                     .getMethod("getApplet", new Class[0]);

      Object applet = method.invoke(handler, new Object[0]);
      if (applet instanceof Main) {
         formsMain = (Main)applet;
      }    
    }catch(Exception ex) {;} 

Then create and deploy the new JAR file to your /forms/Java folder.

Par Oracle Forms community - Publié dans : Bean - general
Send a comment - See the 0 comments
Dimanche 6 février 7 06 /02 /Fév 13:21

Purpose

Here is a Pluggable Java Component from Andreas Weiden, to have expandable/collapsable canvas.

It allows a simple Push Button Item to expand/collapse the whole content of a canvas like a Tree item.

Accordion Java Bean



The Java source
 

     AccordionButton.java



The implementation class of the PJC (PushButton Item)


     forms.AccordionButton


The PJC initialisation

     Read the content of the PK_AKKORDION.txt file from the zip file




The sample dialog

     .
Download the accordion.zip file
     . Unzip the accordion.zip file
     . Copy the accordion.jar file in your /forms/java/ folder
     . Add it to the archive and archive_jini tags of the /forms/server/formsweb.cfg file
     . Open the ACCORDION.fmb and ACCORDION2.fmb modules (Oracle Forms 10.1.2.0.2)
     . Compile all and run the module

 

Par Oracle Forms community - Publié dans : PJC - Buttons
Send a comment - See the 0 comments
Samedi 11 décembre 6 11 /12 /Déc 14:40

Purpose

Here is a Simple Horizontal Scrolling Marquee Java Bean proposed by Omama Khurshid from Taxila Pakistan.

She is working as Software Engineer at Pakistan Revenue Automation Limited Islamabad Pakistan from 3 years and working on PJC from at least 1.5 years for developing different functionality in Oracle forms 10g.
Email address: omamadr@yahoo.com


Text Filed Menu



The Java source
 

     Banner.java



The implementation class of the PJC


     mypackage.Banner


The methods you can call



  • Set the text

Set_Custom_Property ('Blk.Bean',1,'SET_MARQUEE','text#xpos#ypos#textwidth#textheight#fontface#fontsize#fontstyle#fgcolor#bgcolor') ;

Text = 'Some Text '
xpos = 700
ypos=25
width=100
height=25
fontface = 'Serif'
fontsize =16
fontstyle= [I|B|P|BI]
foregroundcolor =r255b0g0
BackgroundColor =r0g0b0
Set_Custom_Property ('Blk.Bean',1,'SET_MARQUEE','Hi I m here #700#25#100#25#Arial#16#I#r255b0g0#r0g0b0') ;

 

  • Stop the marquee

Set_Custom_Property ('Blk.Bean',1,'STOP_MARQUEE','') ;




The sample dialog

     .
Download the marqueePJC.zip file
     .  Unzip the marqueePJC.zip file
     .  Copy the banner.jar file in your /forms/java/ folder
     .  Add it to the archive and archive_jini tags of the /forms/server/formsweb.cfg file
     . Open the banner.fmb module (Oracle Forms 10.1.2)
     . Compile all and run the module

     The jar file must be signed
     The jar file provided with the .zip file is already signed


Par Oracle Forms community - Publié dans : Bean - general
Send a comment - See the 0 comments
Mardi 21 septembre 2 21 /09 /Sep 07:24

Here is a Java Bean to attrack the attention of the end-user when a message is displayed in the status bar.

It "flashes" the status bar using different colors, depending on the message severity.

 

Get This Java Bean created by Andreas Weiden.

Par Oracle Forms community - Publié dans : Bean - general
Send a comment - See the 0 comments
Créer un blog gratuit sur over-blog.com - Contact - C.G.U. - Rémunération en droits d'auteur - Signaler un abus - Articles les plus commentés