We are using SDAC 9.3.x at the moment. We testes 9.4.x and 10.x but we have some issues with batch executes:
We are using a procedure to add insert statements dynamicly to a batch execute.
We do this the following way:
Code: Select all
procedure BatchExec.prcSetAsString(const _sParam: String; _iRow: Integer; const _sValue: String);
var
objParam: TMSParam;
begin
qry.Parameters.ValueCount := iRowCount + 1;
Inc(iRowCount);
objParam := qry.ParamByName(_sParam);
objParam.DataType := ftMemo;
objParam.Values[_iRow].Value := _sValue;
end;
If you increase the ValueCout Value String parameters are resetted. (Only string fields, other fields work just fine). In 9.3.x and lower there is no issue with this code. Since this issue only exists with string fields i think this is a bug.
Could you assist me, to resolve this issue?
Greetings from Germany