12 Replies Latest reply: Feb 21, 2012 11:48 PM by 917676 RSS

    Google search in combolist?

      hi all,
      I'm using 10.2 on windows.
      my question is:
      how i make a search like google website?
      so when i write one letter in combo list the results will added to list that carry the first letter i entered. and when i write the second letter the results contain my two letters and so on.
      the results came from a specific column in specific table.
      and when delete the letters and write a new letter the results come with new letters.

      thank you
        • 1. Re: Google search in combolist?
          Michael Ferrante-Oracle
          You can get some of that behavior using an LOV rather than a list item, but if that is not enough you will need to engineer your own Java Bean to perform the task. The Oracle Forms Demos include numerous Bean examples, however more current examples can be found here:

          (Not an Oracle site)

          Oracle Forms Downloads (from Oracle)
          • 2. Re: Google search in combolist?
            François Degrelle
            <p>Maybe this Java Bean should do the job.</p>
            • 3. Re: Google search in combolist?
              thank you
              but i do not work with java bean and i not understand it
              could you explain it to me briefly or give me a link to do that.
              i did the work but not exactly when i'm writing letter. it's work after i hit enter-key and when i delete the letter for new input the 40735 error occur.

              • 4. Re: Google search in combolist?
                François Degrelle
                Paste, here, the content of the modified /forms/server/formsweb.cfg section (archive tags).
                Also, when you use Java Bean, always display the Java console at runtime to see error messages.

                • 5. Re: Google search in combolist?
                  hi Francois,
                  i didn't modified the formsweb.cfg.
                  i understand that the java bean is component added to oracle. when we need it we just call it...... is that true?
                  i download a PJC component and i can't run it...
                  could you explain how to run it step by step please...

                  thank you

                  • 6. Re: Google search in combolist?
                    François Degrelle
                    +"...i didn't modified the formsweb.cfg..."+

                    But the required steps are explained at the end of the article:
                    The sample dialog

                    . Download the CBAutoCompletion.zip file
                    . Unzip the file
                    . copy the ComboBoxCompletion.jar file in the <ORACLE_HOME>/forms/java directory
                    . Edit your /forms/server/formsweb.cfg file to add the ComboBoxCompletion.jar .
                    . Open the CBAUTOCOMPLETION.fmb module (Oracle Forms 9.0.2)
                    . Compile all and run the module

                    Copy the ComboBoxCompletion.jar file to your <DEVSUITE>/forms/java folder.
                    In your <DEVSUITE>/forms/server folder you will find a formsweb.cfg file. Edit it, then add the ComboBoxCompletion.jar to all the archive and archive_jini tags:
                    save the file.
                    When you run the form, display the Java Console to see if any errors are raised.

                    • 7. Re: Google search in combolist?
                      hi Francois
                      thank you.
                      i saw the steps but what i change in formsweb.cfg thats i didn't now. now is clear.
                      i will try it and tell
                      thank you again.

                      • 8. Re: Google search in combolist?
                        there is an error with java!

                        • 9. Re: Google search in combolist?
                          François Degrelle
                          When you run the form, you see a small coffe-cup in right side of the launch bar. Right click that icon the choose "display console".
                          • 10. Re: Google search in combolist?
                            hi Francois,
                            sorry for late
                            this is the java console

                            Loading http://<client-IP>:8889/forms/java/frmall_jinit.jar from JAR cache
                            Loading http://<client-IP>:8889/forms/java/ComboBoxCompletion.jar from JAR cache
                            connectMode=HTTP, native
                            forms version
                            BGPATTERN:null BACKGROUND:java.awt.Color[r=225,g=225,b=225]
                            VISIBLE:true INIT:Ester,Jordi,Jordina,Jorge,Sergi

                            java.lang.VerifyError: (class: oracle/forms/fd/CBAutoCompletion$4, method: <init> signature: (Loracle/forms/fd/CBAutoCompletion;Ljavax/swing/JComboBox;)V) Expecting to find object/array on stack      
                            at oracle.forms.fd.CBAutoCompletion.<init>(CBAutoCompletion.java:36)      
                            at oracle.forms.fd.ComboBoxCompletion.setProperty(ComboBoxCompletion.java:128)      
                            at oracle.forms.handler.ComponentItem.setCustomProperty(Unknown Source)
                            at oracle.forms.handler.ComponentItem.onUpdate(Unknown Source)      
                            at oracle.forms.handler.JavaContainer.onUpdate(Unknown Source)      
                            at oracle.forms.handler.UICommon.onUpdate(Unknown Source)      
                            at oracle.forms.engine.Runform.onUpdateHandler(Unknown Source)      
                            at oracle.forms.engine.Runform.processMessage(Unknown Source)      
                            at oracle.forms.engine.Runform.processSet(Unknown Source)      
                            at oracle.forms.engine.Runform.onMessageReal(Unknown Source)      
                            at oracle.forms.engine.Runform.onMessage(Unknown Source)      
                            at oracle.forms.engine.Runform.sendInitialMessage(Unknown Source)      
                            at oracle.forms.engine.Runform.startRunform(Unknown Source)      
                            at oracle.forms.engine.Main.createRunform(Unknown Source)      
                            at oracle.forms.engine.Main.start(Unknown Source)      
                            at sun.applet.AppletPanel.run(Unknown Source)      
                            at java.lang.Thread.run(Unknown Source)

                            so what i do?

                            • 11. Re: Google search in combolist?
                              François Degrelle
                              Well, you did not provide the very fisrt lines of the Java Console, but it seems that you run with the JInitiator, that does not support inline classes. Do you have a chance to test it with the Sun(Oracle) plug-in ?

                              • 12. Re: Google search in combolist?
                                yes this JInitiator console.
                                the steps of java environment console you gave it to me. I do it and the console was this.....