SQLStr := 'select * from studen where xm like ''%剑%''';
SQLStr := 'select * from studen where xm like ''%剑%'''; if SQLStr.count >0 then FOR I := 0 to SQLStr.count -1 do memo1.line.asdd(AQLStr.fieldbyname('xm').asstring);
在edit1控件的onchange事件里面 写如下代码String Str := 'select * from studen where xm like %'+Edit1.Text+'% '; query.sql.sqlStr= Str; query.open; memo1.clear; FOR I := 0 to query.count -1 do memo1.line.asdd(query.fieldbyname('xm').asstring);
if SQLStr.count >0 then
FOR I := 0 to SQLStr.count -1 do
memo1.line.asdd(AQLStr.fieldbyname('xm').asstring);
写如下代码String Str := 'select * from studen where xm like %'+Edit1.Text+'% ';
query.sql.sqlStr= Str;
query.open;
memo1.clear;
FOR I := 0 to query.count -1 do
memo1.line.asdd(query.fieldbyname('xm').asstring);