Utility Functions and C Language Reference > Virtual Table Server Functions (VTS) for C, C#, and Java > Virtual Table Server (VTS) Functions for Multiple Connections > Alphabetical Listing > vtc_rotate_messages1

vtc_rotate_messages1

Retrieves the first field from the specified column and moves the value to the bottom.

C Language

vtc_rotate_messages1 ( PVCI2 pvci, char *columnNames, char *delimiter, char **outvalue, unsigned char sendflag );

C# Language

bool vts_multi.rotate_messages ( int pvci,  string [] columnNames, string delimiter, string [] outvalue, string sendflag );

Java Language

int Vtc.rotate_messages1 ( int pvci, String columnNames, String delimiter, OutArrOfStrParameter outvalues, int sendFlag );

Query Functions

Arguments

name Comments
pvci The server connection handle.
columnNames The column name, separated by the delimiter.
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.
outValues Pointer to a string to store retrieved values.
sendflag Specify how the value is added back to bottom. One of:
  • VTSEND_SAME_ROW - Send all the data to the same row.
  • VTSEND_STACKED - The data is sent to availables field at the bottom of each column.
  • VTSEND_STACKED_UNIQUE - If the value of the first field already exists elsewhere in the column, the top field is retrieved and then discarded. Otherwise, data is sent to an available field at the bottom of the column.

vtc_rotate_messages1 retrieves the data in the first field of each specified columns, and stores it in a parameter with the same name as the source column. The data is removed from each first field and moved to the bottom of each column as specified by the unsigned char sendflag.

If there is no data in a cell, the output is NULL.

Return Values

Returns zero on success or one of the Error Codes.

Parameterization

All string input arguments can be passed using standard parameterization.

C Language Example

    vtc_rotate_messages1( pvci, "Country,City", ",", &outValues, VTSEND_SAME_ROW);
    lr_log_message( "Country=%s,City=%s", outValues[0], outValues[1] );
    vtc_free_list(outValues);
 	

C# Language Example

.Net Multiple Connection Example

Java Language Example

Java Multi-Connection Example