SQL server 2005: a problem with parameters of system stored procedures
Posted: Thu 08 Mar 2007 11:25
Hello, I have a problem with getting parameters of system stored procedures using TSQLStoredProc/Delphi7 with driver version 3.10.8. While trying to poll the constraints of some table using sp_helpconstraint, I get "Parameter 'objname' not found" error, when I try to specify the parameter value (Params.Count is 0). The code:
When ParamCheck is set to FALSE and the parameter is created manually, the error is "List index out of bounds (0)" on sp.Open.
When StoredProcName is 'master.sys.sp_helpconstraint' the errors are the same.
Something wrong with my code or with the driver?
Code: Select all
sp := TSQLStoredProc.Create(nil);
sp.SQLConnection := msBase;
sp.StoredProcName := 'sp_helpconstraint';
sp.ParamByName('objname').AsString := 'PmtItems';
sp.Open;
When StoredProcName is 'master.sys.sp_helpconstraint' the errors are the same.
Something wrong with my code or with the driver?