1 Reply Latest reply: Aug 5, 2013 2:00 AM by HansJK RSS

    4.0EA1 DM Import from Designer view wrong

    user13430807

      Hello,

       

      when using the import of an Oracle Designer model, the view definition is malformed in Data Modeler when the select text of a column in Designer is appended with a comment.

      For example, in Designer the select text of the column is: tab1.column1 -- comment

      during the import of the view, the comma is appended to the line, being interpreted as a comment.

       

      In Designer the following is generated (part of view definition):

                ,CAT1.ARTIKEL_CATEGORIE_KD

                ,CAT2.ARTIKEL_CATEGORIE_KD --W6

                ,asx_bep_art_prijs(art.artikel_kd)

       

      In data modeler the view definitionis like:

          CAT1.ARTIKEL_CATEGORIE_KD BOEKSOORT,

          CAT2.ARTIKEL_CATEGORIE_KD --W6 BINDWIJZE,

          asx_bep_art_prijs(art.artikel_kd) PRIJS,

       

      So the import should should prefix the select text with a comma instead of appending.

       

      Best regards,

       

      Joop

        • 1. Re: 4.0EA1 DM Import from Designer view wrong
          HansJK

          Hi

           

          I would like to echo Joop's suggestion to rather put the comma at the start of each line (prefix), when generating the select text.  It alleviates many issues (such as the one highlighted in Joop's topic) and it is our own internal SQL coding standard for just that reason.

           

          I hope my 'like' of this topic counts as a vote for the suggestion.

           

          Regards