dbRsUpdateField ( )

Updates a particular field ( column ) in the current row of the active recordset

Usage:

dbRsUpdateField (object me, string fieldName, any newValue)

Parameter:

fieldName (string) - The field name to update

newValue (strings/integers/floats) - The new value to place in 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.dbRsMoveFirst( )
xtRose.dbRsUpdateField( "Car", 99 )

Notes: