Avi
Joined: 28 Aug 2003 Posts: 2
|
Posted: Thu Aug 28, 2003 6:48 pm Post subject: param not sent to sp |
|
|
It seems like sp_help never gets the table name I sent it. I get a result set a though I did not send any param. Is this a bug?
with SQLStoredProc1 do begin
Params.Clear;
Params.CreateParam(ftString, 'P1', ptInputOutput);
ParamByname('P1').AsString := 'SYS_WATCHDOG';
StoredProcName := 'sp_help';
Open;
s := SQLStoredProc1.Fields[0].value;
end; |
|