SQL server 2005: a problem with parameters of system stored procedures

Omegasoft · Post by **Omegasoft** » 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:

Code: Select all

    sp := TSQLStoredProc.Create(nil);
    sp.SQLConnection := msBase;
    sp.StoredProcName := 'sp_helpconstraint';
    sp.ParamByName('objname').AsString := 'PmtItems';
    sp.Open;

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?

Jackson · Post by **Jackson** » Mon 12 Mar 2007 09:03

Thank you for information.
We have reproduced the problem and fixed it.
This fix will be included in the next DbxSda build.
Please watch for announcements at the forum.