当前位置:编程学习 > Delphi >>

delphi7读数据库,数据库的字段Fflag值是1或0,现在我想让他显示在dbgrid中显示是或否

补充:能不能用sql语句解决,我的sql语句是“select openo as 业务编号,opename as 业务名,ywtype.pno as 业务打印规则, Fflag as 满号循环,Cbeno as 打印最小值,Cmax as 打印最大值,nextopeno as 下级业务 from ywtype,ywprint where ywtype.pno=ywprint.pno”能否在里面加个case when来解决这个问题
追问:提示“未指定的错误”
答案:select ynn=case  yn when 1 then '是' when 0 then '否' end from T1
-----------------------------------------------------------------------------
select openo as 业务编号,opename as 业务名,ywtype.pno as 业务打印规则, Cbeno  as  打印最小值,  满号循环=case Fflag   when 0 then '否' when 1 then '是' end,Cmax as 打印最大值,nextopeno as 下级业务  from ywtype,ywprint  where ywtype.pno=ywprint.pno
-----------------给分吧---------再有不会的找我-----------------------------
其他:直接用DBGridEh,数据库字段类型设置为bit类,直接可以满足你的需求,如果是DBGrid的话,貌似要绑定CheckBox 网上有好多例子,我就不给你复制粘贴了。。~ 

上一个:Delphi中[Hint] Prj_load.dpr(23): Value assigned to 'pdatabuffer' never used是什么意思?
下一个:delphi运行环境?

CopyRight © 2012 站长网 编程知识问答 www.zzzyk.com All Rights Reserved
部份技术文章来自网络,