select Case status when 0 then '未更新' when 1 then '更新失败' when 2 then '更新成功' end from 表
试一下,在DBGrid的onDrawColumnCell事件中加入以下代码: if Column.Field.FieldName ='status' then begin if Column.Field.AsInteger = 0 then DBGrid1.Canvas.TextRect(Rect,0,0,'未更新'); if Column.Field.AsInteger = 1 then DBGrid1.Canvas.TextRect(Rect,0,0,'更新失败'); if Column.Field.AsInteger = 1 then DBGrid1.Canvas.TextRect(Rect,0,0,'更新成功'); end;
case status when 0 then '未更新' when 1 then '更新失败' when 2 then '更新成功' end as ##
select Case status when 0 then '未更新' when 1 then '更新失败' when 2 then '更新成功' end
select decode(status,0,'未更新',1,'更新失败',2,'则显示更新成功') a from 表 oracle
from 表
if Column.Field.FieldName ='status' then
begin
if Column.Field.AsInteger = 0 then
DBGrid1.Canvas.TextRect(Rect,0,0,'未更新');
if Column.Field.AsInteger = 1 then
DBGrid1.Canvas.TextRect(Rect,0,0,'更新失败');
if Column.Field.AsInteger = 1 then
DBGrid1.Canvas.TextRect(Rect,0,0,'更新成功');
end;
from 表
oracle