When developing a database model, there is usually such a need to enter a Chinese name of a table or field to automatically generate its Chinese Pinyin first alphabetic function such as: device _ transformer automatically forms database table name SB_BYQ can set this in PowerDesigner 9.5 or later Open 1. Tools> ModelOptions .. dialog 2. Click on the left Name Convension tree node 3. Select the Name / Code Convensions Select Box 4 in the right panel. Enter the following code in the CONVENSITION Script input box in the Name / Code page
.foreach_part (% Name%, "."). VBScript (% currentpart%) scriptresult = getpy (scriptinputArray (0)) Function getpychar (char) TMP = 65536 ASC (char) IF (TMP> = 45217 and TMP <= 45252) THEN getPychar = "a" Elseif (TMP> = 45253 and TMP <= 45760) ThengetPychar = "b" elseif (TMP> = 45761 and TMP <= 46317) THENGETPYCHAR = "c" elseif (TMP> = 46318 and TMP <= 46825) THENGETPYCHAR = "D" Elseif (TMP> = 46826 and TMP <= 47009) THEN getPychar = "e" elseif (TMP> = 47010 and TMP <= 47296) THEN getPychar = "f" elseif (tmp> = 47297 and TMP <= 47613) Then getpychar = "g" elseif (TMP> = 47614 and TMP <= 48118) ThengetPychar = "h" elseif (TMP> = 48119 and TMP <= 49061) THENGETPYCHAR = "J" Elseif (TMP > = 49062 and TMP <= 49323) Then getpychar = "k" elseif (TMP> = 49324 and TMP <= 49895) THEN getpychar = "l" elseif (TMP> = 49896 and TMP <= 50370) THEN getPychar = "m "Elseif (TMP> = 50371 and TMP <= 50613) Then getpychar =" n "elseif (tmp> = 50614 and tmp <= 50621) THEN getpychar =" o "elseif (TMP> = 50622 and TMP <= 50905) THENGETPYCHAR = "P" elseif (tmp> = 50906 and TMP <= 51386) Then getpychar = "q" elseif (TMP> = 51387 and TMP <= 514 45) Then getpychar = "r" elseif (TMP> = 51446 and TMP <= 52217) THEN getpychar = "s" elseif (tmp> = 52218 and tmp <= 52697) THEN getPychar = "t" elseif (tmp> = 52698 And TMP <= 52979) THEN getPychar = "w" elseif (tmp> =
