怎么用ADOQUERY做模糊查询(100分)

Q

qweasd1981

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-08-07

• #1

怎么用ADOQUERY做模糊查询

 

C

coolcat3000

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-08-07

• #2

var key:string
begin
ADoQuery1.close;
AdoQuery1.SQL.Clear;
AdoQuery1.Sql.Add('select * from ' +Table+ ' where ' + key +' like "%'+edit1.Text+'%"');
AdoQuery1.open;

 

Q

qweasd1981

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-08-07

• #3

谢谢！

 

黎

黎永欢

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-08-07

• #4

和TQuery的用法相似，只要熟悉SQL语句就行了。