Extensions.SQL.NextResult

Classification

Name	NextResult
Short Description	Moves the cursor forward one row from its current position.
Class	Term
Extension	OTX SQL extension
Group	SQL related Terms
Exceptions
Checker Rules
Standard Compliant	Yes

OTL Syntax

BooleanTerm SQL.NextResult(ResultSetTerm resultSet);

Description

The NextResult term moves the cursor forward one row from its current position. A ResultSet cursor is initially positioned before the first row; the first call to the term NextResult makes the first row the current row; the second call makes the second row the current row, and so on. When a call to the NextResult term returns false, the cursor is positioned after the last row.

Return Value

The Term returns the value, see table below.

In OTX, Terms are categorized according to its return data type!

Data Type	Description
Boolean	When a call to the NextResult term returns false, the cursor is positioned after the last row.

Properties

Name	Data Type	Class	Default	Cardinality	Description
resultSet	ResultSet	Term	-	[1..1]	This element represents the result set from which the next row will be selected.

OTL Examples

	/// Local Declarations

	SQL.Connection Connection1;
	SQL.ResultSet ResultSet1;
	Boolean Boolean1;

	/// Flow

	try
	{
		// for DotNet platform
		Connection1 = SQL.CreateConnection("DRIVER={SQL Server};Server=.;InitialCatalog=classicmodels;username=sa;password=saas");
	}
	catch (Exception)
	{
		// for Java platform
		Connection1 = SQL.CreateConnection("jdbc:sqlserver://localhost;databaseName=classicmodels;username=sa;password=saas");
	}

	SQL.ExecuteQuery(Connection1, "select * from classicmodels.dbo.orders", ResultSet1);
	Boolean1 = SQL.NextResult(ResultSet1);

	while (Boolean1) : WhileLoop1
	{
		Boolean1 = SQL.NextResult(ResultSet1);
	}

	SQL.CloseConnection(Connection1);

See also

CloseConnection
ExecuteQuery
ExecuteUpdate
ConnectionTerm
ConnectionValue
CreateConnection
GetResultValueAsBoolean
GetResultValueAsByteField
GetResultValueAsFloat
GetResultValueAsInteger
GetResultValueAsString
NextResult
ResultSetTerm
ResultSetValue