Opens a recordset from a stored procedure
Usage:
dbRsOpenQuery (object me, string queryName, object parmNameList, object parmValueList)
Parameter:
queryName - (string) Name of the stored procedure in the data provider
parmNameList - (list of strings) A list containing the names of each parameter required by the stored procedure
parmValueList - ( list of strings/integers/floats) A list, with the same number of items as parmNameList, containing value to be passed to each parameter. The order of the values in this list must match the order of parameter names in parmNameList. The data type of each item could be a Director string, integer, or float. The data type used in Director should match the data type being expected in the stored procedure.
Returns:
(integer) - The success code
Example:
xtRose = xtra("Rosetta").new( )
xtRose.dbOpen( "Provider=MSDASQL;ExtendedAnsiSQL=2;DRIVER={Microsoft Access Driver (*.mdb)};Dbq="&the moviepath&"main" )
xtRose.dbRsOpenQuery( "oldCars", ["manufacture", "cost", "year"], ["dodge", 24000.25, 1994] )
Notes:
Recordset functions are only available after opening a valid database connection. Once you are done with the recordset, be sure to call dbRsClose( ) to close the recordset
Not all data providers support stored procedure. For example, csv files do not support stored procedures. Microsoft Access is an example of a data provider supporting stored procedures.