Scripting/Squirrel/Functions/GetSQLNextRow

From Vice City Multiplayer
Revision as of 10:13, 26 April 2019 by Dracc (talk | contribs) (Cleanup example code)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
Caution icon
This wiki is using an old backup from 2020
Some information may be old/missing

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) {
  // Select all the rows that has the same uniqueid as the entered value.
  local query = QuerySQL(sdb, "SELECT namecolumn FROM tablename WHERE uniqueidcolumn = '" + uniqueid + "'");
  // Store the first name.
  local string = GetSQLColumnData(query, 0);

  // Get the second name when the loop starts and continue getting the next row after that until no rows are left.
  while (GetSQLNextRow(query)) {		
    string += ", " + GetSQLColumnData(query, 0);
  }
  string += ".";

  // Return the string containing the aliases. 
  return string;
}

Related Functions