DBgrid的问题!

Question

select a.*, b.x from a,b where b.x in(select b.x from b where b.x=a.number)

Answer 1

LookUp 是最简单的，你也可以用DrawDataCell事件
procedure TForm.DBGrid1DrawDataCell(Sender: TObject;
  const Rect: TRect; Field: TField; State: TGridDrawState);
begin
  if Field.Value=1 then
  DBGrid1.Canvas.TextRect(rect,2,2,男)
  else
  DBGrid1.Canvas.TextRect(rect,2,2,女)；
end;

Answer 2

Lookup 最简单，试试这个
procedure TFilterForm.DBGrid1DrawDataCell(Sender: TObject;
  const Rect: TRect; Field: TField; State: TGridDrawState);
begin
  if Field.Value=1 then
  DBGrid1.Canvas.TextRect(rect,2,2,男)
  else
  DBGrid1.Canvas.TextRect(rect,2,2,女)

Answer 3

Lookup字段在那里啊？我怎么没有找到？

Answer 4

如果是sql server ,sql中使用case