W
wataki
Unregistered / Unconfirmed
GUEST, unregistred user!
bde连接oracle9i数据库
视图用中文命名字段,sql bulider取出来的居然是乱麻
SELECT "#O##", KGYZB_ID, SBGYS_ID, "##E###", GB, DZ, DH, YB, SB_SBGYSYLB_BZ, "#u#####a", "#u##d###", ZBLX, SB_KGYZBYLB_BZ, "#O##IdEo#####a", "d#######", "#OE#####", "#U##E###E###", "E#A###A#", "#a##AN####I#D#AN##", "#U##AU##", "#ia#"
FROM SBV_MJCGJHB Sbv_mjcgjhb
--ANSI== SELECT Sbv_mjcgjhb."#O##", KGYZB_ID, SBGYS_ID, Sbv_mjcgjhb."##E###", GB, DZ, DH, YB, SB_SBGYSYLB_BZ, Sbv_mjcgjhb."#u#####a", Sbv_mjcgjhb."#u##d###", ZBLX, SB_KGYZBYLB_BZ, Sbv_mjcgjhb."#O##IdEo#####a", Sbv_mjcgjhb."d#######", Sbv_mjcgjhb."#OE#####", Sbv_mjcgjhb."#U##E###E###", Sbv_mjcgjhb."E#A###A#", Sbv_mjcgjhb."#a##AN####I#D#AN##", Sbv_mjcgjhb."#U##AU##", Sbv_mjcgjhb."#ia#"
--ANSI== FROM SBV_MJCGJHB Sbv_mjcgjhb
用select *也不行
但在oracle里面显示正常
langdriver选择了Oracle SQL WE850
视图用中文命名字段,sql bulider取出来的居然是乱麻
SELECT "#O##", KGYZB_ID, SBGYS_ID, "##E###", GB, DZ, DH, YB, SB_SBGYSYLB_BZ, "#u#####a", "#u##d###", ZBLX, SB_KGYZBYLB_BZ, "#O##IdEo#####a", "d#######", "#OE#####", "#U##E###E###", "E#A###A#", "#a##AN####I#D#AN##", "#U##AU##", "#ia#"
FROM SBV_MJCGJHB Sbv_mjcgjhb
--ANSI== SELECT Sbv_mjcgjhb."#O##", KGYZB_ID, SBGYS_ID, Sbv_mjcgjhb."##E###", GB, DZ, DH, YB, SB_SBGYSYLB_BZ, Sbv_mjcgjhb."#u#####a", Sbv_mjcgjhb."#u##d###", ZBLX, SB_KGYZBYLB_BZ, Sbv_mjcgjhb."#O##IdEo#####a", Sbv_mjcgjhb."d#######", Sbv_mjcgjhb."#OE#####", Sbv_mjcgjhb."#U##E###E###", Sbv_mjcgjhb."E#A###A#", Sbv_mjcgjhb."#a##AN####I#D#AN##", Sbv_mjcgjhb."#U##AU##", Sbv_mjcgjhb."#ia#"
--ANSI== FROM SBV_MJCGJHB Sbv_mjcgjhb
用select *也不行
但在oracle里面显示正常
langdriver选择了Oracle SQL WE850