2 Replies Latest reply: Aug 28, 2013 10:51 AM by @c*689064* RSS

    SQLDEV 4EA1: code editor: code templates don't work

    @c*689064*

      We are testing SQLDEV 4, because we want to migrate from SQLDEV 3.3.

      We have a lot of code-templates, but they don't work in SQLDEV 4EA1 any more.

      For example:

      ID          template

      ----------------------------------------------------------------------------------
      -----------------------------------------------------------------------------------
      --#date# #time#

       

      SQLDEV 3.3: Typing '--' and then using the short cut for code templates generates '-------------------------------------------------------------------------------'

      SQLDEV 4EA1: Typing '--' and then using the short cut for code templates generates nothing

       

      We tried to use the ID='kkk' for

      template='--------------------------------------------------------------------------------

      --#date# #time#'

       

      but the #date# #time# functionality didn't work.

       

      Please reimplement the code template behavior of SQLDEV 3.x and before.

      Because we mainly use SQLDEV for scripting with code templates, this would be one of the highest criteria for migration to SQLDEV 4 in our company.

       

      Thanks, Chris

        • 1. Re: SQLDEV 4EA1: code editor: code templates don't work
          Jeff Smith Sqldev Pm-Oracle

          Do the sql developer supplied templates work? I'm trying to reproduce your test case but I'm confused, surely your actual template isn't '--' which explodes to '---------------------------------------------' or is it?

          • 2. Re: SQLDEV 4EA1: code editor: code templates don't work
            @c*689064*

            Maybe that makes it clearer.

             

            1. This is a copy (from grid) of a SQLDEV - preferences - code template:

             

            ----------------------------------------------------------------------------------

             

            Typing '--' in code editor in SQLDEV 3.x and then pressing 'ctrl-space' generates '---------------------------------------------------------------', which is correct.

            By typing '--' in code editor in SQLDEV 4EA1 and then pressing 'ctrl-space' nothing happens.

             

            2. We tried to rename the ID of an similar template:

             

            kkk--------------------------------------------------------------------------------
            --#date# #time#

             

            Typing 'kkk' in code editor in SQLDEV 3.x and then pressing 'ctrl-space' generates '---------------------------------------------------------------

            2013-08-28 ....', which is correct (incl. new-line character)

             

            By typing 'kkk' in code editor in SQLDEV 4EA1 and then pressing 'ctrl-space' generates:

             

            '

            --------------------------------------------------------------------------------

            --#date# #time#

            ' which is wrong, because the variables #date# #time# should be replaced by the current date and time.

             

            So there are two kinds of errors.