为何我的这些代码只能在书写为一行，一回车换行就不行呢

Question

adoq_employee.SQL.Add('insert into shzf.EMPLOYEE(IDCARD,SPOUSE_IDCARD,NAME,GENDER,COMPANY,MARRIAGE,JOB_START_TIME,RETIRE_TIME,DEAD_TIME,PHONE_NUMBER) values (:adda1,:adda2,:adda3,:adda4,:adda5,:adda6,:adda7,:adda8,:adda9,:adda10)');

Answer 1

adoquery_employee.sql.add('insert into shzf.employee');
adoquery_employee.sql.add('(IDCARD,SPOUSE_IDCARD,NAME,GENDER,COMPANY,MARRIAGE,JOB_START_TIME,RETIRE_TIME,DEAD_TIME,PHONE_NUMBER) values )');
adoquery_employee.sql.add('(:adda1,:adda2,:adda3,:adda4,:adda5,:adda6,:adda7,:adda8,:adda9,:adda10)');
尝试一下可不可以:)

Answer 2

分成几部分，进行add就可以了。

Answer 3

var
  SqlStr:String;
begin
  SqlStr:='insert into shzf.employee';
  SqlStr:=SqlStr+'(IDCARD,SPOUSE_IDCARD,NAME,GENDER,COMPANY,MARRIAGE,JOB_START_TIME,RETIRE_TIME,DEAD_TIME,PHONE_NUMBER) values )';
  SqlStr:=SqlStr+'(:adda1,:adda2,:adda3,:adda4,:adda5,:adda6,:adda7,:adda8,:adda9,:adda10)';
  adoquery_employee.sql.add(SqlStr);
end;