Function.ODBC.Connection!conname.RunStoredProcRst

From GAB Help
Jump to: navigation, search

This executes the specified stored procedure, against the specified database connection, and returns the results in the specified recordset.

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")

Remarks