请问adoquery中怎样实现与bdequery中的parambyname('')的功能啊？（20分）(20分)

N

nottop

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-04-28

• #1

多谢

 

T

Tassadar

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-04-28

• #2

adoquery.parameters.parambyname

 

C

cwmdelpher

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-04-28

• #3

ADOQuery1.Parameters[0].Value

 

C

cwmdelpher

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-04-28

• #4

ADOQuery1.Parameters.ParamByName()

 

胡

胡红兵

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-04-28

• #5

好象两者使用方法一致没有区别

 

N

nottop

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-04-28

• #6

但是.asstring是怎么实现的啊，麻烦了！用.value老是报错！多谢！

 

N

nottop

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-04-28

• #7

up

 

游

游泳的鱼

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-04-28

• #8

ADOQuery1.Parameters.ParamByName('name')

 

T

Tassadar

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-04-28

• #9

用.value是没错的，可能你要设置一下param的类型
例如
ADOQuery1.Parameters.ParamByName('name').DataType := ftString;
ADOQuery1.Parameters.ParamByName('name').Value := 'a name';

 

N

nottop

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-04-28

• #10

with data.qry_bj01 do
begin
close;
sql.Clear;
sql.Add('insert into bangjiao(f01,f02,f03,f04,f05,f06) ');
sql.Add(' valuesf01,:f02,:f03,:f04,:f05,:f06)');
parameters.parambyname('f01').value:=lsb_31.Items.Strings;
parameters.parambyname('f02').value:=lsb_33.Items.Strings;
parameters.parambyname('f03').value:=datetostr(now());
parameters.parambyname('f04').value:=lsb_32.Items.Strings;
parameters.parambyname('f05').value:=trim(memo_31.Text);
parameters.parambyname('f06').value:='';
execsql;//此处提示数据精度错误，怎样处理啊
close;

 

N

nottop

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-04-28

• #11

多谢！

 

N

nottop

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2003-04-28

• #12

问题解决