2 Replies Latest reply on Apr 17, 2020 7:00 AM by Peter2_1

    Code template: .FMFFMLFFUKFFILFFGLFFIMFFKLFF

    Peter2_1

      Via "Preferences I added my first two (very simple) code templates to the standard "codetemplate.xml". Both are doing fine, but when I opened the XML, I found this in lines 39-40:

      <?xml version = '1.0' encoding = 'UTF-8'?>
      <rows>
         <row>
            <key>cf</key>
            <value>CREATE FUNCTION function_name
                [ (parameter) ]
                RETURN return_datatype
                IS
                    [declaration_section]
                BEGIN
                    ...
                END function_name;
            </value>
         </row>
         <row>
            <key>cp</key>
            <value>CREATE PROCEDURE procedure_name
            [ (parameter]) ]
            IS
                [declaration_section]
            BEGIN
                ...
            END procedure_name;
            </value>
         </row>
         <row>
            <key>ct</key>
            <value>CREATE TABLE table ()</value>
         </row>
         <row>
            <key>df</key>
            <value>DELETE FROM table WHERE </value>
         </row>
         <row>
            <key>ii</key>
            <value>INSERT INTO table VALUES ()</value>
         </row>
         <row>
            <key>.FMFFMLFFUKFFILFFGLFFIMFFKLFF</key>
            <value>FHFFFHFFFHFFFHFFIJFFGJFFIKFFKJFFFHFFMKFFMKFFUKFFFKFFOJFFUKFFIKFFKJFFIJFFJKFFOJFFUJFFTJFFTHFFOJFFJJFFUKFFLJFFKKFFTJFFIJFFJKFFOJFFUJFFTJFFUKFFNJFFOJFFKJFFHKFFSFFFPFFFFHFFFHFFFHFFFHFFFHFFFHFFFHFFFHFFMKFFNJFFKJFFTJFFFHFFGIFFFHFFFHFFFHFFJKFFNJFFKJFFTJFFFHFFMHFFGLFFTLFFJLFFKLFFHMFFKLFFMHFFSFFFPFFFFHFFFHFFFHFFFHFFFHFFFHFFFHFFFHFFMKFFNJFFKJFFTJFFFHFFHIFFFHFFFHFFFHFFJKFFNJFFKJFFTJFFFHFFMHFFGJFFHMFFKLFFGLFFRLFFKLFFTLFFJMFFMMFFJTFFIMFFIMFFKLFFHMFFKMFFTLFFMLFFMHFFSFFFPFFFFHFFFHFFFHFFFHFFFHFFFHFFFHFFFHFFKJFFRJFFIKFFKJFFFHFFMHFFSHFFSHFFSHFFSHFFMHFFFHFFFHFFFHFFFHFFFHFFFHFFFHFFFHFFFHFFFHFFFHFFFHFFFHFFFHFFFHFFFHFFFHFFFHFFFHFFFHFFFHFFFHFFFHFFFHFFSFFFPFFFFHFFFHFFFHFFFHFFKJFFTJFFJJFFFHFFFHFFFHFFFHFFFHFFFHFFFHFFFHFFFHFFFHFFFHFFFHFFFHFFFHFFFHFFFHFFFHFFFHFFFHFFFHFFFHFFFHFFFHFFFHFFFHFFFHFFFHFFFHFFFHFFFHFFFHFFFHFFFHFFFHFFFHFFFHFFFHFFGJFFIKFFFHFFHHFFNJFFOLFFKLFFHMFFGLFFHMFFILFFNLFFOLFFKLFFHHFF</value>
         </row>
         <row>
            <key>ssf</key>
            <value>SELECT * FROM table</value>
         </row>
         <row>
            <key>pg_where_date</key>
            <value> WHERE
          DATE_INSTALLATION != TO_DATE ('01.01.1800', 'dd.mm.yyyy')
             AND (DATE_INSTALLATION &lt; TO_DATE ('01.01.1950', 'dd.mm.yyyy')
              OR DATE_INSTALLATION > TO_DATE ('01.01.2030', 'dd.mm.yyyy'))
      </value>
         </row>
      </rows>
      

       

      What's this?

       

      Peter