Devart Forums

Posted: **Wed 10 Jun 2009 06:07**

Hello!

I have such code:

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.

Posted: **Wed 10 Jun 2009 13:31**

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.

Devart Forums

Migration from ADO to SDAC.

Migration from ADO to SDAC.