您所在位置：主题：pb建立视图问题,在线等,火急
houquanpeng
[专家分：0] 发布于 2007-06-08 10:55:00
请问我用pb6.5和sql2000建立一个视图,以前用pb6.5+asa7的时候可以这样
CREATE VIEW view_yj_xhy
(zdw,c1,lxdz,dydh,btqy,lx) AS
SELECT str_xhy_input.zdw,
case month(today()) when month(yjsj1) then date(yjsj1) when month(yjsj2) then date(yjsj2) when month(yjsj3) then date(yjsj3) when month(yjsj4) then date(yjsj4) end as c1 ,
str_xhy_input.lxdz,
str_xhy_input.dydh,str_xhy_input.btqy,
str_xhy_input.cllx
FROM str_xhy_input where string(c1)<>'' and str_xhy_input.btqy='用';
但现在换成2000后,case后不允许有任何的比如month,double等,而且也不能在条件中输入0 to 100,有谁知道,告诉一声行吗?很急,在线等
CREATE VIEW view_yj_xhy
(zdw,c1,lxdz,dydh,btqy,lx) AS
SELECT str_xhy_input.zdw,
case month(today()) when month(yjsj1) then date(yjsj1) when month(yjsj2) then date(yjsj2) when month(yjsj3) then date(yjsj3) when month(yjsj4) then date(yjsj4) end as c1 ,
str_xhy_input.lxdz,
str_xhy_input.dydh,str_xhy_input.btqy,
str_xhy_input.cllx
FROM str_xhy_input where string(c1)<>'' and str_xhy_input.btqy='用';
但现在换成2000后,case后不允许有任何的比如month,double等,而且也不能在条件中输入0 to 100,有谁知道,告诉一声行吗?很急,在线等