Adds a new row of data to the active recordset
Usage:
dbRsAddRowData (object me, object rowFieldNameList, object rowFieldValueList)
Parameter:
rowFieldNameList (list of strings) - A list containing the names of each field used in the recordset
rowFieldValueList (strings/integers/floats) - A list of values to add into the data file, with the same number of items as parmNameList. 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 for the field.
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.dbRsOpen( 2, "Select * from Test" )
xtRose.dbRsAddRowData( ["manufacture", "cost", "year"], ["dodge", 24000.25, 1994] )
Notes: