Utility Functions and C Language Reference > Virtual Table Server Functions (VTS) for C, C#, and Java > Virtual Table Server (VTS) Functions for Single Connection > Alphabetical Listing > lrvtc.rotate_Row


Retrieves the first row and moves the values to the bottom.

C Language

lrvtc_rotate_row (  sendflag );

C# Language

void vts.rotate_row ( string sendflag  );

Java Language

int Lrvtc.rotate_row ( int sendFlag );

Query Functions


name Comments
sendflag Specify how the values are added back to bottom. One of:
  • VTSEND_SAME_ROW - Send all the data to the same row.
  • VTSEND_STACKED - The data is sent to available fields 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.

lrvtc_rotate_row retrieves the data in the first row and stores them in parameters with the same name as the columns. The data is removed from the first row and moved to the bottom of the columns as specified by the sendFlag.

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

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.


All string input arguments can be passed using standard parameterization.

C Language Example


C# Language Example

.Net Single Connection Example

Java Language Example

Java Single Connection Example