with qryProblem do
begin
Close;
SQL.Clear;
SQL.Add('insert into tproblem (l_id, vc_title) values (seq_problem.nextval, ''":'') ');
ExecSQL;
end;
会出现以下错误:
Missing right quote.
begin
Close;
SQL.Clear;
SQL.Add('insert into tproblem (l_id, vc_title) values (seq_problem.nextval, ''":'') ');
ExecSQL;
end;
会出现以下错误:
Missing right quote.
begin
Close;
SQL.Clear;
SQL.Add('insert into tproblem (l_id, vc_title) values (seq_problem.nextval, quotedstr(''));
ExecSQL;
end;
如果是空字符串的话,则:with qryProblem do
begin
Close;
SQL.Clear;
SQL.Add('insert into tproblem (l_id, vc_title) values (seq_problem.nextval, '''')');
ExecSQL;
end;