Command参数问题
程序代码如下:
with Form1.MyComm do
begin
Parameters.Clear;
CommandText:='update quotedprice set IsExist=1,ResponseTime=now(),CarOwner=:@CarOwner,'+
'CarRegisterDate=:@CarRegisterDate,CarSeatAmount=:@CarSeatAmount,CarTonnage=:@CarTonnage,'+
'CarModel=:@CarModel,CarEnginenumber=:@CarEnginenumber,standardPrice:=@standardPrice where id=:@Id;';
Parameters.Refresh;
Parameters[0].value:= GetControlValue(ParentHandle,R.Left+135,R.Top+137);
Parameters[1].value:= GetControlValue(ParentHandle,R.Left+135,R.Top+169);
Parameters[2].value:= GetControlValue(ParentHandle,R.Left+135,R.Top+201);
Parameters[3].value:= GetControlValue(ParentHandle,R.Left+383,R.Top+201);
Parameters[4].value:= GetControlValue(ParentHandle,R.Left+633,R.Top+233);
Parameters[5].value:= GetControlValue(ParentHandle,R.Left+134,R.Top+295);
Parameters[6].value:= GetControlValue(ParentHandle,R.Left+29,R.Top+419);
Parameters[7].value:= P.Id;
Prepared:=true;
Form1.Memo1.Lines.Insert(0,CommandText);
Execute;
end;
这时输出的Sql语句是:update quotedprice set IsExist=1,ResponseTime=now(),CarOwner=:@CarOwner,CarRegisterDate=:@CarRegisterDate,CarSeatAmount=:@CarSeatAmount,CarTonnage=:@CarTonnage,CarModel=:@CarModel,CarEnginenumber=:@CarEnginenumber,standardPrice:=@standardPrice where id=:@Id;
请问这加参数到底是怎么用呀?