Forum Discussion
Hi Yan01,
Please refer to the Call and SQL Stored Procedure article - it contains a ready-to-use script.
- Yan015 years agoOccasional Contributor
Hi:
I read through the article, but not sure this part: Call SProc.Parameters.AddParameter() SProc.Parameters.Items(0).name = "RETURN_VALUE" SProc.Parameters.Items(0).DataType = adInteger SProc.Parameters.Items(0).Direction = adParamReturnValue SProc.Parameters.Items(0).Value = Null
For example: if I have a stored procedure A that has multiple parameter B, C, and D, then it has multiple lines of AddParameter function from 0 - 2? Another question, in the example script, there are multiple variables: DataType, Size, Direction, Value, what is the meaning of each one? If one of the paramater has value of XML format, how is it working?
- TanyaYatskovska5 years agoSmartBear Alumni (Retired)
Hi Yan01,
A number of the AddParameter methods should be the same as a number of parameters you want to declare. Plus, make sure that you declared that out parameter (if a stored procedure returns something).
As for other variables, you can find a detailed description in the Working with Stored Procedure Parameters article of the VCL documentation.
Related Content
Recent Discussions
- 18 hours ago
- 2 days ago