Subject RE: [IBO] Re: Creating a Stored Procedure at runtime
Author Helen Borrie
At 11:10 AM 04-12-01 +0200, you wrote:
>Hi
>I tried it but there does not exist a ParamNames property.
>I could also not find anything that looked like it would
>add a parameter.

No; the component gets and populates the Params itself, when the statement is prepared. So, call Prepare first, then *read* the Params property and do what what you need with your variables in AfterPrepare.

Also, be aware that results returned from TIB_StoredProc don't show up in Params[] but in Fields[].

regards,
Helen

All for Open and Open for All
InterBase Developer Initiative ยท http://www.interbase2000.org
_______________________________________________________