用query实现
1: select * from table1,table2... where 人名='XXX'
2: select * from table1 where 人名='xxx'
3: select * from table1 where 人名 like '%XXX%'
1: select * from table1,table2... where 人名='XXX'
2: select * from table1 where 人名='xxx'
3: select * from table1 where 人名 like '%XXX%'
query.close;
query.clear;
query.sql.add(memo);
query.open;
memo.text的值=上面的sql语句就是了
var
tablename,fieldname:string;
begin
tablename:='???';
fieldname:='???';
query.close;
query.sql.text:='select * from '+tablename+' where '+fieldname+' =...'
query.open;
end;
只要对主表查询一次就可以了!
当然要用QUERRY来作了,表的同步在教科书上有,
查询用楼上的也行!这里就不獒述了!
例如:
令query.sql='select * from :tablename where :fieldname=:fieldvalue;那么在query的param属性中会出现三个值(tablename,fieldname,fieldvalue)在程序中使用时:
query.active:=False;
query.parambyname('tablename'):=***;
query.parambyname('fieldname'):=***;
query.parambyname('fieldvalue'):=***;
query.active:=True;query.parambyname()后面要不要.asstring等东西,我不记得了。一试就知道了。
query.close;
query.sql.text:='select * from '+tablename+' where '+fieldname+' =...'
query.open;
with query do
beign
close;
sql.clear;
sql.add('select * from Tablename where FieldName= :FieldValue')
params.items[0]:=Value;
end;
你想如何用都可以