Question

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来解决这个问题

Answer 1

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
-----------------给分吧---------再有不会的找我-----------------------------

追问

提示“未指定的错误”

Answer 2

直接用DBGridEh，数据库字段类型设置为bit类，直接可以满足你的需求，如果是DBGrid的话，貌似要绑定CheckBox 网上有好多例子，我就不给你复制粘贴了。。~