Hello

Hello
I'm trying to Delphi DataSnap server using xe7 with MSSQL database. I have a GetAnyProc method. This metod is call storedprocedure use TFDStoredProc. when i call getanyproc method then my sql procedure is run twice. When i call sp doing insert then inserted doblicate row.

function TServerMethods1.GetAnyProc(const Tip, SqlStr, ParamStr: string): TFDJSONDataSets;
begin
  GenProc.Active := False;
  GenProc.Params[1].Value := Tip;
  Result := TFDJSONDataSets.Create;
  TFDJSONDataSetsWriter.ListAdd(Result, GenProc);
end;

can anyone help

Comments