Question

delphi ，修改oracle数据库数据

with qry1 do
begin
Close;
SQL.Clear;
SQL.Add('update spirit_patient set NAME:=pa,NAME_PHONETIC:=pb where patient_id:='''+edt1.Text+''' ');
Parameters.ParamByName('xpid').value := Trim(edt1.Text);
Parameters.ParamByName('pa').Value:=trim(edtName.Text);
Parameters.ParamByName('pb').value := Trim(edtNamePhonetic.Text);
........

ExecSQL;
end;
逐行检查也没发现错误啊，怎么回事啊

Answer 1

set NAME:=pa 这么写 set NAME=‘pa’

Answer 2

sql里没有参数'xpid'