用query组件中的sql语句怎样进行模糊查询？(20分)

Z

zhuifeng

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-11-09

• #1

根据edit.text的内容进行模糊查询。用query组件 ，sql语句应该怎样写？
是不是需要用其他的组件？

 

J

Joy_Wang

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-11-09

• #2

query1.add('select * from table');
query1.add('where name like '''+'%'+edit1.text+'%'+'''');
这样随便你怎么模糊了,前后的%号随便你要那一个

 

血

血青色

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-11-09

• #3

query.close;
query.sql.clear;
query.sql.add(select *from tablename where 字段 like 'edit.text%')
query.open

 

轩

轩辕散光

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-11-09

• #4

query1.add('select * from 表名');
query1.add('where 字段名 like '''+edit1.text+'%'+'''');

 

C

chshanghai

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-11-09

• #5

query1.close;
query1.sql.clear;
query1.sql.add('select * from tablename where fieldname like :var1 ');
query1.parambyname('var1').value:='%'+edit1.text+'%';
open;

 

C

chshanghai

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-11-09

• #6

错了
上面的最后一句应改为
query1.open

 

M

mouseboy

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-11-09

• #7

query1.add('select * from table');
query1.add('where name like :name');
query1.ParamByName('name').AsString := '%'+edit1.text+'%';

 

D

DELPHI鸟

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-11-09

• #8

query.close;
query.sql.clear;
query.sql.add(select *from tablename where 字段 like'%'+edit1.text+'%' Oredit1.text+'%' or%'+edit1.text)
query.open
反正你就随便模糊去吧！

 

B

bright78

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-11-09

• #9

字串中含有edit1.text查找
query1.close;
query1.sql.clear;
query1.sql.add('select * from tablename where fieldname like :var1 ');
query1.parambyname('var1').value:='%'+edit1.text+'%';
open;
以edit1.text開頭的字串查找
query1.close;
query1.sql.clear;
query1.sql.add('select * from tablename where fieldname like :var1 ');
query1.parambyname('var1').value:='+edit1.text+'%';
open;

 

老

老蔡

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-11-09

• #10

我没话说了,

 

Y

yangh

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-11-09

• #11

like拉！

 

F

Flintstone

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-11-09

• #12

来晚了。

 

Z

zhuifeng

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-11-10

• #13

多人接受答案了。