使用ＳＱＬ查询语句时如何带入变量？(100分)

斌

斌斌

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-09-06

• #1

使用ＡＤＯ控件时，用ＳＱＬ查询语句时如何带入变量？
我原来使用query1时以下语句可以使用，但改用ADOQuery1时提示错误了，如何解决？请大侠相助！
原语句如下：
query1.close;
query1.sql.Clear;
query1.sql.add('select * from paword where 操作员=:username');
query1.parambyname('username').asstring:=edit1.text;
session.addpassword('ZHB');
query1.open;

 

完

完颜康

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-09-06

• #2

with ADOQuery1 do
begin
close;
sql.Clear;
sql.add('select * from paword where 操作员=:username');
Parameters.ParamByName('username').asstring:=edit1.text;
open;
end;

 

L

lcl800

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-09-06

• #3

query1.close;
query1.sql.Clear;
query1.sql.add('select * from paword where 操作员='+edit1.text);
session.addpassword('ZHB');
query1.open;

 

高

高小五

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-09-08

• #4

with ADOQuery1 do
begin
close;
sql.Clear;
sql.add('select * from paword where 操作员=:username');
Parameters.ParamByName('username').Value :=edit1.text;
open;
end;

 

W

why_119

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-09-08

• #5

如果一条sql语句中有多个变量呢？

 

M

micro73

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-09-11

• #6

sql.add(Format('select * from 薪资表 where(%s%s''%s'') order by %s',['工号',sign,Edit1.Text,'工号']));

 

斌

斌斌

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-27

• #7

OK