adoquery的动态查询问题,急(50分)

N

njcw666

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-12

• #1

我用
sql.Add('select number from holiday');
sql.Add('where number=:num');
如何为:num 赋一个值 如 edit1.text

 

无

无疯无禄

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-12

• #2

Sqa.ParamByName('Nun').AsInteger:=StrToInt(Edit1.text)
类型变化

 

L

lanbing1400

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-12

• #3

with adoquery do
close;
sql.clear;
sql.add('select * from database where field like :field');
parambyname('field').asstring:='%'+dd+'%';
open

 

P

panjf

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-12

• #4

ADOQuery.Parameters.ParamByName('num').Value := num;

 

银

银雨辰

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-12

• #5

with adoquery do
begin
close;
sql.clear;
sql.Add('select number from holiday where number=:num');
ParamByName('num').asinteger := strtoint(edit1.text);
Prepare;
Open;
end;

 

B

babyboom

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-12

• #6

with adoquery do
begin
close;
sql.clear;
sql.Add('select number from holiday where number=:'''+strtoint(edit1.text)+''' ');
Prepare;
Open;
end;

 

N

njcw666

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-12

• #7

spl.ParamByName('num').asinteger := strtoint(edit1.text);这种用法用于query1
adoquery1 的用法为panjf ADOQuery.Parameters.ParamByName('num').Value := num;

 

D

delphiandoracle

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-12

• #8

ADOQuery.Parameters.ParamByName('num').Value := num;

 

九

九月飞鹰

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-12

• #9

同意无疯无禄的看法

 

双

双流星

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-12

• #10

改一下
with adoquery1 do
begin
close;
sql.clear;
sql.Add('select number from holiday where number='''+edit1.text+'''');
Open;
end;

 

N

njcw666

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-01-06

• #11

接受答案了.