procedure TForm1.Button2Click(Sender: TObject); begin query1.Close; query1.SQL.Clear; query1.SQL.Add('select * from student where age between '''+trim(edit2.text)+'''and '''+trim(edit3.text)+''''); query1.SQL.Add(' order by age desc'); query1.Open; end
回复 | 推荐 | 收藏 | 专题 | 公告 | 管理 | 关闭窗口
主 题: 怎么在’query‘重量需使用select?
作 者: ponycsdn (宇际之星)
等 级:
信 誉 值: 100
所属论坛: Delphi
问题点数: 20
回复次数: 2
发表时间: 2002-4-22 17:52:37
procedure TForm1.Button2Click(Sender: TObject);
begin
query1.Close;
query1.SQL.Clear;
query1.SQL.Add('select * from student where age between '''+trim(edit2.text)+'''and '''+trim(edit3.text)+'''');
query1.SQL.Add(' order by age desc');
query1.Open;
end