紧急求救 sql中除法问题

Question

with ADOQ_QD do
    begin
      close;
      sql.Clear;
      sql.Add('SELECT sum(wro.required_quantity)/:sl');
      sql.Add('FROM WIP_REQUIREMENT_OPERATIONS WRO');
      Parameters.ParamByName('sl').Value:=k;
      open;
    end;
报错：ORA-01036 ;非法的变量名/编号
该怎么做？？？急

Answer 1

with ADOQ_QD do
    begin
      close;
      sql.Clear;
      sql.Add('SELECT sum(wro.required_quantity)*:sl');
      sql.Add('FROM WIP_REQUIREMENT_OPERATIONS WRO');
      Parameters.ParamByName('sl').Value:=1/k;
      open;
    end;

Answer 2

with ADOQ_QD do
    begin
      close;
      sql.Clear;
      sql.Add('SELECT sum(wro.required_quantity)*1/:sl');
      sql.Add('FROM WIP_REQUIREMENT_OPERATIONS WRO');
      Parameters.ParamByName('sl').Value:=k;
      open;
    end;

Answer 3

哥们，还是报错：ORA-01036 ;非法的变量名/编号
该怎么做？？？急

Answer 4

SELECT msib1.segment1, sum(wro.required_quantity)*(1/:sl)
好啦，谢谢！！！