i user pd16.6 reverse engineer extact mysql5.6 physical model.
if column had default value ,colum is enclolsed by character '~' , not character '(quote).
just like
i changed setting,just like
.problem still exist!
who can help me !
-
i used jdbc connection.
i try to user odbc connection,this problem is not occur,but other problem occur.
i don't know where to find 'line of SQL'.
thanks!
-
Are you reverse-engineering from a DB connection, or SQL? What does the line of SQL look like?
2 Answers
-
Best AnswerJun 04 at 02:35 PM
Hello,
As a workaround, you may run a VBScript after the reverse like the one below which can be included in the XDB file in an AfterDatabaseReverseEngineer Eventhandler for the Metaclass Model.
See in our documentation -> DBMS Resource File Reference > Managing Generation and Reverse Engineering -> Adding Scripts Before or After Generation and Reverse Engineering
' Sample script:for each t in ActiveModel.Tables
if t.ClassName = "Table" then
for each c in t.Columns
if c.ClassName = "Column" then
if len(c.DefaultValueDisplayed) > 2 and InStr(c.DefaultValueDisplayed,"~") = 1 then
newDefault = c.DefaultValueDisplayed
newDefault = left(newDefault, len(newDefault) - 1)
newDefault = right(newDefault, len(newDefault) - 1)
c.DefaultValue = newDefault
end if
end if
next
end if
next
HTH,Arnaud
Add comment
-
Jun 05 at 05:19 AM
that is OK!
"our documentation" just means "help document":)
thank you very much!
Add comment
Add comment