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):
In data modeler the view definitionis like:
CAT2.ARTIKEL_CATEGORIE_KD --W6 BINDWIJZE,
So the import should should prefix the select text with a comma instead of appending.
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.