Migration from ADO to SDAC.

[Saupg]

Hello!

I have such code:

Code: Select all

var
  spOper: TADOStoredProc;
begin
  ....
  spOper.ProcedureName := ProcName;
  if spOper.Parameters.Refresh then
    spOper.Parameters.ParamByName('Param').Value := AValue;
  else
    Exception.CreateFmt('Stored proc ''%s'' not found', [ProcName]);

How i can rewrite it using SDAC? I need to check stored proc.

[Dimon]

You can't know if the procedure exist until you try to execute it, using, for example, the ExecProc method.
If you need to get list stored procedure names you should use the TMSConnection.GetStoredProcNames method.