vtc.updateRow1

Sets the values of specified fields in a row.

Syntax

vtc.updateRow1 ( columnNames, rowIndex ,  values,  delimiter );

Example

Data Update Functions

Arguments

name	Comments
columnNames	The list of the columns to write to.
rowIndex	The number of the row. The first row has index 1.
values	The list of values to write to the columns.
delimiter	The character that separates the column names and values in the lists. If a string, rather than a single character, is passed in delimiter, the string as a whole is the delimiter.

vtc.updateRow1 sets the values of the fields specified by columnNames in the row specified by rowIndex.

Return Values

Returns zero on success or one of the Error Codes.

Parameterization

All string input arguments can be passed using standard parameterization.

Example

function callback(){
    var name = 'x' + arguments.callee.caller.arguments.callee.caller;
    lr.message( name.match(',(.*)_wrapper')[1] + '\'s callback arg:');
    for(var i=0 ;i<arguments.length; ++i){
        lr.message( 'arg[' + i + '] type: ' + typeof arguments[i] + ' =' + arguments[i]);
    }
}

function Action()
{
    var handle2 = vtc.connect('321.321.321.321', 8889, vtc.VTOPT_KEEP_ALIVE);
    var handle1 = vtc.connect('123.123.123.123', 8888, vtc.VTOPT_KEEP_ALIVE);  
    lr.message('handle1: '+ handle1.handle + ' handle2: ' + handle2.handle);
    
    if(handle2.handle!==0){
        handle2.createColumn('CID_2', callback );  
        handle2.updateMessage('CID_2', 1, 'bbbb', callback );       
    }
    
    if(handle1.handle!==0){
        handle1.createColumn('CID_1', callback );
        handle1.sendMessage('CID_1', '111', callback );
        handle1.sendMessage('CID_1', '2222', callback );
        handle1.updateMessage('CID_1', 1, 'aaaaa', callback );
        handle1.columnSize('CID_1', callback );
        handle1.queryColumn('CID_1', 1, callback );     
        handle1.rotateRow(vtc.VTSEND_SAME_ROW, callback );
        handle1.queryRow(1, callback ); 
        handle1.rotateMessage('CID_1', vtc.VTSEND_SAME_ROW, callback );
        handle1.rotateMessages1('CustomerID,CompanyName', ',', vtc.VTSEND_SAME_ROW, callback );
        handle1.clearColumn('CID_1', callback );        
        handle1.getLastError( callback );
        handle1.disconnect( callback );
    }
    
    if(handle2.handle!==0){
        handle2.disconnect( callback );
    }
}