Scripting/Squirrel/Functions/GetSQLNextRow

Calling GetSQLNextRow switches from the current row in a query to the next row, which allows you to read from that row with GetSQLColumnData.

Syntax

function GetSQLNextRow( query )

Arguments

• Query - A reference to the query that was previously executed.

Example

function GetAlias( uniqueid )
{
	local query = QuerySQL(sdb, "SELECT namecolumn FROM tablename WHERE uniqueidcolumn = '" + uniqueid + "'"); // Selects all the rows that has the same uniqueid as the entered value.
	local string = GetSQLColumnData(query, 0); // Stores the first name.
	
	while (GetSQLNextRow(query)) // Gets the second name when the loop starts and continues getting the next row after that until no rows are left.
	{
		
		string += ", " + GetSQLColumnData(query, 0);
	}
	string += ".";
	return string; // Returns the string containing the aliases. 
}

Related Functions

• ConnectSQL
• DisconnectSQL
• escapeSQLString
• FreeSQLQuery
• GetSQLColumnCount
• GetSQLColumnData
• GetSQLNextRow
• QuerySQL

Related Functions

• ConnectSQL
• DisconnectSQL
• escapeSQLString
• FreeSQLQuery
• GetSQLColumnCount
• GetSQLColumnData
• GetSQLNextRow
• QuerySQL