比方说,我想把满足条件name=edit.text记录的所有book都添加到listbox1中.
这是我当初的程序,一条一条找,太慢了,如果用SQL查询怎么做??
.....
while not adoquery1.Eof do
begin
if trim(adoquery1.fieldbyname('name').asstring)=trim(edit1.text) then
listbox1.Items.Add(adoquery1.fieldbyname('book').asstring);
adoquery1.Next;
end;
......
这是我当初的程序,一条一条找,太慢了,如果用SQL查询怎么做??
.....
while not adoquery1.Eof do
begin
if trim(adoquery1.fieldbyname('name').asstring)=trim(edit1.text) then
listbox1.Items.Add(adoquery1.fieldbyname('book').asstring);
adoquery1.Next;
end;
......
with adoquery1 do
begin
close;
sql.clear;
sql.text:='select * from yourtable where name='+''''+trim(edit1.text)+'''';
open;
while not eof do
begin
listbox1.items.add(adoquery1.fieldbyname('book').asstring);
next;
end;
end;