1 2 3 Previous Next 41 Replies Latest reply on Apr 23, 2020 8:40 PM by Michael Ferrante-Oracle Go to original post
      • 30. Re: Forms Feature Requests
        Frank Hoffmann

        Richard,

         

        for this purpose I can recommend an excellent tool that not only allows comparision between old and new (inclusive properties) but also allows to merge changes. Forms Api Master

         

        Here a short example .. comparison between webutil 12.2.1.3 and webutil 12.2.1.4.

        A doubleclick would show the differences for one procedure in Detail.

         

         

        Frank

        • 31. Re: Forms Feature Requests
          Michael Ferrante-Oracle

          Richard, it sounds like what you really need/want is a version control system.  Oracle's Developer Cloud Service might be what you need.  If you control the XML version of your forms you can use the DCS tools to manage various versions and changes.  Diffs and even code changes are possible if you use XML.  I demo'd using DCS for Forms modules in 2018.  I created a paper showing how we did it, but that was in 2018.  Since 2018 the DCS UI has changed a bit so the screenshots aren't exactly the same as what you might see today.  Also, DCS currently only has Forms 12.2.1.3.  We are working on a 12.2.1.4 software bundle for DCS and we are hoping to publish it soon.

           

          https://www.oracle.com/technetwork/developer-tools/forms/documentation/oracleforms-in-dcs-5216022.pdf

          • 32. Re: Forms Feature Requests
            Richard Harrison

            All

             

            As my searches haven't found anything, I presume it is not currently possible to do the following at runtime in a POST-QUERY trigger on a block: -

             

            if :=BLOCK1.STATUS = 1 then

                  SET_ITEM_INSTANCE_PROPERTY('BLOCK1.PUSH_BUTTON1',CURRENT_RECORD, PROMPT_TEXT, 'ON');

            else

                 SET_ITEM_INSTANCE_PROPERTY('BLOCK1.PUSH_BUTTON1',CURRENT_RECORD, PROMPT_TEXT, 'OFF');

            end if;

             

            this is attempting to set button text per record based upon a value in the database.

             

            If this is not currently possible, then this would also be on my "wish" list for a future release

             

            Regards

             

            Richard

            • 33. Re: Forms Feature Requests
              dsscott

              I'd like to see more built in functions within Forms or at least some Forms specific packages in the database that can be called. Also, less reliance on Java since none of my developers have any experience with Java.

              • 34. Re: Forms Feature Requests
                Michael Ferrante-Oracle

                dsscott wrote:

                 

                I'd like to see more built in functions within Forms or at least some Forms specific packages in the database that can be called. Also, less reliance on Java since none of my developers have any experience with Java.

                Can you be more specific?  Exactly what would you like these built-ins to accomplish (specifically)?  Keep in mind that you an already call many of the packages that exist in the db.  Although you do have to be careful about version matching.  In other words, if you are using Forms 12.2.1.4 but are connecting to a 19.3 db you may (in some cases) be limited to the functionality that exists in 12.1.  This is because Forms 12.2.1.4 is based on db 12.1 and 12.1 PL/SQL. 

                 

                Regarding Java, the only reason you would need to have any Java skills is if you wanted to extend Forms using Java. In fact, if what you want to extend has nothing to do with the UI, you don't have to use Java.  You could use C (server or client).  You could use JavaScript (client).  You can even call out the OS or other applications or libraries that are on the machine (client or server).

                • 35. Re: Forms Feature Requests
                  dsscott

                  My reference to database packages was mainly in case it would be easier to add features to Forms such as BLOB support thru a package rather than internal to Forms.

                  • 36. Re: Forms Feature Requests
                    Richard Harrison

                    All

                     

                    Another one for the list (I presume this thread is still open).

                     

                    Simple formatting tools within Forms Builder would be useful, especially when writing Triggers, even for things like

                    • toggling between lowercase and UPPERCASE,
                    • code indentation (I know that the builder attempts this in some cases already),
                    • commenting / uncommenting blocks of code

                     

                    Any tools that help make the code readable following a template rather than the developer deciding when to indent and not to indent, etc.

                     

                    Regards

                     

                    Richard

                    • 37. Re: Forms Feature Requests
                      Michael Ferrante-Oracle

                      Richard Harrison

                       

                      Thank you for your suggestions.  We will certainly consider them.  In the mean time, note that there are a few configuration changes that can be made in the current versions.  However, to enable/set them you must set environment variables.  These settings are not visible directly in the Builder (yet )

                       

                      DE_PREFS_TABSIZE (Windows only)

                      Sets the number of spaces that represent a tab.  So as an example if you set the value to 5, 5 spaces will be inserted for each time you press Tab in the PLSQL Editor.  It uses the same value when carriage returning to the next line.

                       

                      TK2_HIDE_EDITOR_LINE_NUMBER  (Windows only)

                      Setting this to 1 or TRUE will turn off line numbering in the Editor.  This will resemble what we had in v10

                      • 38. Re: Forms Feature Requests
                        Richard Harrison

                        Thanks for the reply, Michael.

                        • 39. Re: Forms Feature Requests
                          Richard Harrison

                          Hi Frank

                           

                          I have just checked out the website for Forms API master and it looks like the extra functions are great.

                           

                          It is a shame that this is a "paid" application and that similar functions could not be added to Forms Builder.

                           

                          Regards

                           

                          Richard

                          • 40. Re: Forms Feature Requests
                            Sanal Krishnan Narayanan

                            My wish list - Improve the pl/sql editor :

                            - click to go to procedure definition  - like in other language code editors, select or hold and click to go to the (in case of overloaded procedures, the correct one ) procedure definition.

                            - A better Find-and-replace interface - after opening the code editor, when I highlighted a phrase (for e.g.) , if it could highlight all other instances of this phrase in the same page/code.  Have up/down & wrap search direction

                            - show procedure name(s) as its being typed in code like Intellisense

                            • 41. Re: Forms Feature Requests
                              Michael Ferrante-Oracle

                              Sanal Krishnan Narayanan

                               

                              Thank you for your suggestions.  We will be considering all received suggestions, but of course can only deliver a limited number of what is received.

                              1 2 3 Previous Next