怎么用Edit的输入来查询(50分)

L

lzc1980

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-04-21

• #1

怎么用Edit的输入来查询

 

张

张剑波

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-04-21

• #2

SQL.Add('Select * from xian.db where XM :=myxm');
ParamByName('myxm').AsString := edit1.text;

 

Z

zhao0707

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-04-21

• #3

sql.add(format('select * from xxx.db where xx:=%s',[edit1.text]));

 

Z

zlqzlqzlq

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-04-21

• #4

SQL.Add('Select * from xian.db where XM =:myxm'); //冒号应在等号右边做为参数
ParamByName('myxm').AsString := edit1.text;
或者
SQL.Add('Select * from xian.db where XM ='''+edit1.text+''''); //冒号去掉

 

张

张剑波

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-04-21

• #5

sorry:
" XM :=myxm" error
"XM =:myxm" ok

 

L

liuxiaouo

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-04-21

• #6

1。最常用的带参数查询：
query1.SQL.Add('Select * from tablename where fieldname =:myfield');
query1.ParamByName('myfield').AsString := trim(edit1.text);
query1.ParamByName('myfield').Asinteger := strtoint(trim(edit1.text));
2。匹配查询：
query1.sql.add('Select * from tablename where fieldname like "%'+Edit1.text+'%"');

 

荷

荷塘新月

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-04-21

• #7

同意LIUXIAOUO：
1。最常用的带参数查询：
query1.SQL.Add('Select * from tablename where fieldname =:myfield');
query1.ParamByName('myfield').AsString := trim(edit1.text);
query1.ParamByName('myfield').Asinteger := strtoint(trim(edit1.text));
2。匹配查询：
query1.sql.add('Select * from tablename where fieldname like "%'+Edit1.text+'%"');


对于初学者，方法1比较合适；对于熟练者，方法2比较合适。

 

C

cubel

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-04-21

• #8

query1.sql.add('Select * from tablename where fieldname like "%'+Edit1.text+'%"')
这句俺最喜欢用了

 

X

xiuguo

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-04-22

• #9

同意cubel.多简单，而且不包含什么参数！

 

L

lzc1980

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-04-22

• #10

谢谢！

 

H

han

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-04-22

• #11

Query1.Close;
Query1.SQL.Text := Format('select * from table1 where id=%s',[Edit1.Text]);
Query1.Open