Function.ODBC.Connection!conname.RunStoredProcRst
This executes the specified stored procedure, against the specified database connection, and returns the results in the specified recordset.
Contents
Syntax
Function.ODBC.Connection.RunStoredProcRst(stored proc name [String], recordset name [String])
Function.ODBC.Connection.RunStoredProcRst(stored proc name [String], recordset name [String], param names [String], param types [Long], param sizes [Long], param vals [String])
Arguments
stored proc name
[String]
recordset name
[String]
param names
[String]
List of Input and Output parameters that needs to be passed to the stored procedure. It is a good practice to match these names with the parameter names in the stored procedure definition.
param types
[Long]
Datatype of the parameters.
0 - Boolean
1 - Date-Time
2 - Float
3 - Integer
4 - String
param sizes
[Long]
Size of the I/O parameters. By convention, this size should match the parameter size in the procedure definition, and 0 is used for integers.
param vals
[String]
Values for the input parameters. Blank string should be passed for output parameter.
Examples
Function.ODBC.Connection!Conn.RunStoredProcRst("GetVendorInfo","rstVendorInfo","Vendor",4,6,"100845")