lrvtc_update_all_message_ifequals

Searches for a value in the specified columns and, if found, replaces the values in all of the specified columns.

C Language

VTCERR2 lrvtc_update_all_message_ifequals ( char *colNames, char *message , char *ifmessage, char *delimiter );

C# Language

void vts.update_all_message_ifequals ( string colNames, string message , string ifmessage, string delimiter );

Java Language

int Lrvtc.update_all_message_ifequals ( string colNames, string message, string ifmessage, string delimiter );

JavaScript Language

lrvtc.updateAllMessageIfequals ( colNames, message, ifmessage, delimiter);
Data Update Functions

Arguments

Name Comments
colNames The column names, separated by a delimiter
message New value
ifmessage Original value
delimiter The delimiter used as a separator between the columns

lrvtc_update_all_message_ifequals searches for a for a value, ifmessage in the specified columns, colNames. If found, it replaces the value in all of the columns with another value, message.

This function can be used to replace old values, or clear all existing values from a column's rows.

Return Values

C Language:   Returns zero on success or one of the Error Codes.

C# Language: No return value.

Java Language:   Returns zero on success or one of the Error Codes.

JavaScript Language:   Returns zero on success or one of the Error Codes.

Parameterization

All string input arguments can be passed using standard parameterization.

C Language Example

/*If value equals "hello" in columns col1 or col2, replace the value to "hi"*/               
lrvtc_update_all_message_ifequals("col1:col2", "hi", "hello", ":");
/*If value equals "hello" in columns col1 or col2, clear the values*/               
lrvtc_update_all_message_ifequals("col1:col2", "", "hi", ":");