select distinct praid,xh,xhmc,zxbm,zxmc,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,zxrmc,bjjsbz,
(case when wjbz ='0' then '未注銷' when wjbz ='1' then '已注銷' end) wjbz,
xhorder,ywmc,inviteschemeid,jbflag,zbbm from v_cgjhmx_zxqk_ztb
where zbbm ='2016120008'
order by jbflag,xhorder asc,zxbm,zxr 報錯提示無效數字 已確認是視圖問題
CREATE OR REPLACE VIEW V_CGJHMX_ZXQK_ZTB AS
SELECT xh,xhmc,praid,zxbm,zxmc,djbh,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,ERPJHMXID,zxrmc,inviteschemeid,zbbm,'1' bjjsbz,'zbbh' ywmc,'60' xhorder,1 jbflag，null sprq,baoid FROM
v_cgjhmx_zxqk_ztb_20--招標編號
UNION ALL
SELECT xh,xhmc,praid,zxbm,zxmc,djbh,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,ERPJHMXID,zxrmc,inviteschemeid,zbbm,'1' bjjsbz,'invitescheme' ywmc,'70' xhorder,1 jbflag,sprq,baoid FROM
v_cgjhmx_zxqk_ztb_21--招標方案
UNION ALL
SELECT xh,xhmc,praid,zxbm,zxmc,djbh,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,ERPJHMXID,zxrmc,inviteschemeid,zbbm,'1' bjjsbz,'invite' ywmc,'110' xhorder,1 jbflag,sprq,baoid FROM
v_cgjhmx_zxqk_ztb_22--招標公告--【招標通知】
UNION ALL
SELECT xh,xhmc,praid,zxbm,zxmc,djbh,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,ERPJHMXID,zxrmc,inviteschemeid,zbbm,'1' bjjsbz,'bidapply' ywmc,'120' xhorder,1 jbflag,null sprq,baoid FROM
v_cgjhmx_zxqk_ztb_23--投標報名
UNION ALL
SELECT xh,xhmc,praid,zxbm,zxmc,djbh,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,ERPJHMXID,zxrmc,inviteschemeid,zbbm,'1' bjjsbz,'inviteexes' ywmc,'130' xhorder,1 jbflag,null sprq,baoid FROM
v_cgjhmx_zxqk_ztb_24--標書費
--UNION ALL
--SELECT xh,xhmc,praid,zxbm,zxmc,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,zxrmc,inviteschemeid,zbbm,'1' bjjsbz,'inviteclarify' ywmc,'25' xhorder,1 jbflag FROM
--v_cgjhmx_zxqk_ztb_25--投標質疑
UNION ALL
SELECT xh,xhmc,praid,zxbm,zxmc,djbh,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,ERPJHMXID,zxrmc,inviteschemeid,zbbm,'1' bjjsbz,'clarifypublicity' ywmc,'80' xhorder,1 jbflag,null sprq,baoid FROM
v_cgjhmx_zxqk_ztb_26--招標澄清--【澄清修改】
UNION ALL
SELECT xh,xhmc,praid,zxbm,zxmc,djbh,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,ERPJHMXID,zxrmc,inviteschemeid,zbbm,'1' bjjsbz,'deposit' ywmc,'140' xhorder,1 jbflag,null sprq,baoid FROM
v_cgjhmx_zxqk_ztb_27--保證金
UNION ALL
SELECT xh,xhmc,praid,zxbm,zxmc,djbh,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,ERPJHMXID,zxrmc,inviteschemeid,zbbm, bjjsbz,'bid' ywmc,'150' xhorder,1 jbflag,null sprq,baoid FROM
v_cgjhmx_zxqk_ztb_28--投標書
UNION ALL
SELECT xh,xhmc,praid,zxbm,zxmc,djbh,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,ERPJHMXID,zxrmc,inviteschemeid,zbbm,'1' bjjsbz,'bidopen' ywmc,'160' xhorder,1 jbflag,null sprq,baoid FROM
v_cgjhmx_zxqk_ztb_29--開標登記
--UNION ALL
--SELECT xh,xhmc,praid,zxbm,zxmc,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,zxrmc,inviteschemeid,zbbm,'1' bjjsbz,'techaudit' ywmc,'30' xhorder,1 jbflag FROM
--v_cgjhmx_zxqk_ztb_30--技術評標
UNION ALL
SELECT xh,xhmc,praid,zxbm,zxmc,djbh,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,ERPJHMXID,zxrmc,inviteschemeid,zbbm,'1' bjjsbz,'jszjdf' ywmc,'180' xhorder,1 jbflag,null sprq,baoid FROM
v_cgjhmx_zxqk_ztb_31--技術專家打分--【專家評分】
UNION ALL
SELECT xh,xhmc,praid,zxbm,zxmc,djbh,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,ERPJHMXID,zxrmc,inviteschemeid,zbbm,'1' bjjsbz,'busiaudit' ywmc,'200' xhorder,1 jbflag,null sprq,baoid FROM
v_cgjhmx_zxqk_ztb_32--商務評標--【評標報告】
UNION ALL
SELECT xh,xhmc,praid,zxbm,zxmc,djbh,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,ERPJHMXID,zxrmc,inviteschemeid,zbbm,'1' bjjsbz,'swzjdf' ywmc,'190' xhorder,1 jbflag,null sprq,baoid FROM
v_cgjhmx_zxqk_ztb_33--商務專家打分--【評委評分】
UNION ALL
SELECT xh,xhmc,praid,zxbm,zxmc,djbh,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,ERPJHMXID,zxrmc,inviteschemeid,zbbm,'1' bjjsbz,'integrateaudit' ywmc,'210' xhorder,1 jbflag, sprq,baoid FROM
v_cgjhmx_zxqk_ztb_34--定標報告
--UNION ALL
--SELECT xh,xhmc,praid,zxbm,zxmc,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,zxrmc,inviteschemeid,zbbm,'1' bjjsbz,'prepublicity' ywmc,'35' xhorder,1 jbflag FROM
--v_cgjhmx_zxqk_ztb_35--預中標公示
UNION ALL
SELECT xh,xhmc,praid,zxbm,zxmc,djbh,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,ERPJHMXID,zxrmc,inviteschemeid,zbbm,'1' bjjsbz,'publicity' ywmc,'220' xhorder,1 jbflag,sprq,baoid FROM
v_cgjhmx_zxqk_ztb_36--中標公告--【評標結果公示】
UNION ALL
SELECT xh,xhmc,praid,zxbm,zxmc,djbh,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,ERPJHMXID,zxrmc,inviteschemeid,zbbm,'1' bjjsbz,'zbtzs' ywmc,'230' xhorder,1 jbflag,null sprq,baoid FROM
v_cgjhmx_zxqk_ztb_37--中標通知書--【評標通知書】
UNION ALL
SELECT xh,xhmc,praid,zxbm,zxmc,djbh,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,ERPJHMXID,zxrmc,0 inviteschemeid,zbbm,'1' bjjsbz,'cght' ywmc,'250' xhorder,1 jbflag, sprq,baoid FROM
v_cgjhmx_zxqk_ztb_38--采購合同
--UNION ALL
--SELECT xh,xhmc,praid,zxbm,zxmc,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,zxrmc,0 inviteschemeid,zbbm,'1' bjjsbz,'cgjs' ywmc,'39' xhorder,1 jbflag FROM
--v_cgjhmx_zxqk_ztb_39--付款申請單
--UNION ALL
--SELECT xh,xhmc,praid,zxbm,zxmc,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,zxrmc, inviteschemeid,'1' bjjsbz,'zbwj' ywmc,'41' xhorder FROM
--v_cgjhmx_zxqk_ztb_41--招標檔案
--UNION ALL
--SELECT xh,xhmc,praid,zxbm,zxmc,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,zxrmc, inviteschemeid,zbbm,'1' bjjsbz,'zdspb' ywmc,'42' xhorder,1 jbflag FROM
--v_cgjhmx_zxqk_ztb_42--檔案送審
--UNION ALL
--SELECT xh,xhmc,praid,zxbm,zxmc,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,zxrmc, inviteschemeid,zbbm,'1' bjjsbz,'zpbap' ywmc,'43' xhorder,1 jbflag FROM
--v_cgjhmx_zxqk_ztb_43--招評標安排
UNION ALL
SELECT xh,xhmc,praid,zxbm,zxmc,djbh,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,ERPJHMXID,zxrmc, inviteschemeid,zbbm,'1' bjjsbz,'expertchoice' ywmc,'170' xhorder,1 jbflag,null sprq,baoid FROM
v_cgjhmx_zxqk_ztb_44--專家抽取--【評標委員】
UNION ALL
SELECT xh,xhmc,praid,zxbm,zxmc,djbh,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,ERPJHMXID,zxrmc, inviteschemeid,zbbm,'1' bjjsbz,'zgyswj' ywmc,'90' xhorder,1 jbflag,null sprq,baoid FROM
v_cgjhmx_zxqk_ztb_45--資格預審檔案
--UNION ALL
--SELECT xh,xhmc,praid,zxbm,zxmc,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,zxrmc, inviteschemeid,zbbm,'1' bjjsbz,'zgyswjtj' ywmc,'46' xhorder,1 jbflag FROM
--v_cgjhmx_zxqk_ztb_46--資格預審檔案提交
UNION ALL
SELECT xh,xhmc,praid,zxbm,zxmc,djbh,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,ERPJHMXID,zxrmc, inviteschemeid,zbbm,'1' bjjsbz,'zgysbg' ywmc,'100' xhorder,1 jbflag,null sprq,baoid FROM
v_cgjhmx_zxqk_ztb_47--資格預審報告
UNION ALL
SELECT xh,xhmc,praid,zxbm,zxmc,djbh,dwbm,dwmc,zxbz,zxbzmc,zxr,zxrq,wjbz,CGBM,WZBM,ERPJHMXID,zxrmc, inviteschemeid,zbbm,'1' bjjsbz,'depositth' ywmc,'240' xhorder,1 jbflag ,null sprq,baoid FROM
v_cgjhmx_zxqk_ztb_48--保證金退還
/**
* modified by Jiashaokai at 2011/04/08
* 加入bjjsbz ，在業務跟蹤處，如果不等于1，則不能查看詳細內容，默認為1
* ywmc 模塊的業務名稱, xh 標識頁面彈出模塊的方法
* xhmc 頁面顯示的名稱不受此控制
* xhorder 模塊的排序 頁面展示的順序在頁面中控制 不受此引數控制
*/;
這個視圖中所有的SELECT陳述句單獨執行都正確，執行視圖創建陳述句也沒報錯，我懵逼了，請求大神支援！！！！！
uj5u.com熱心網友回復：
你這陳述句跟實際環境關聯性太強了，不好判斷；建議你把這個視圖中，逐段去掉，看看是哪一段出的問題；
uj5u.com熱心網友回復：
zbbm ,是數字型別吧，你的陳述句：where zbbm ='2016120008'，表示是字符型別。請確認，創建視圖時，zbbm 欄位的欄位型別uj5u.com熱心網友回復：
檢查下wjbz 欄位，看是否有非數字的字串。我懷疑問題存在這里。
uj5u.com熱心網友回復：
祝你好運！！！！轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/96368.html
標籤：開發