procedure TForm8.FormShow(Sender: TObject);
begin
Form8.ADOQuery1.close;
Form8.ADOQuery1.SQL.Clear;
Form8.ADOQuery1.SQL.add('select 提醒日期,提醒内容 from reminder');
Form8.ADOQuery1.Prepared;
Form8.ADOQuery1.Open;
while not Form8.ADOQuery1.Eof do
begin
if ADOQuery1.Fields[2].AsDateTime < Date+10 then
begin
showmessage(trim(ADOQuery1.Fields[3].AsString));//显示该行提醒内容
end;
Form8.ADOQuery1.Next;
end;
end;求解!
begin
Form8.ADOQuery1.close;
Form8.ADOQuery1.SQL.Clear;
Form8.ADOQuery1.SQL.add('select 提醒日期,提醒内容 from reminder');
Form8.ADOQuery1.Prepared;
Form8.ADOQuery1.Open;
while not Form8.ADOQuery1.Eof do
begin
if ADOQuery1.Fields[2].AsDateTime < Date+10 then
begin
showmessage(trim(ADOQuery1.Fields[3].AsString));//显示该行提醒内容
end;
Form8.ADOQuery1.Next;
end;
end;求解!
ADOQuery1.Fields[0].AsDateTime
ADOQuery1.FieldByName('提醒日期').AsDateTime
begin
close;
SQL.Clear;
SQL.Add('select 提醒日期,提醒内容 from reminder');//您这里只select 两列
Open;
while not Eof do
begin
if Fields[0].AsDateTime>Date-5 then
begin
showmessage(trim(Fields[1].AsString));//显示该行提醒内容
//这行改变此表格此行的颜色
end;
Next;
end;
end;