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 ;非法的变量名/编号
该怎么做???急
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 ;非法的变量名/编号
该怎么做???急
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;
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;
该怎么做???急
好啦,谢谢!!!