com.remedy.arsys.api
Class SQLResult

java.lang.Object
  com.remedy.arsys.api.SQLResult

public class SQLResult

extends java.lang.Object

The SQLResult class returns a list of result values returned from an SQL query.

Method Summary

Value[][]	getContents() Returns list of zero or more (accessible) rows that match the criteria defined by the sqlCommand value (in the Util.ARGetListSQL class.
int	getTotalNumberOfMatches() Returns the total number of (accessible) rows that match the SQL selection criteria.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Method Detail

getTotalNumberOfMatches

public int getTotalNumberOfMatches()

Returns the total number of (accessible) rows that match the SQL selection criteria. This value does not represent the number of rows returned unless the number of matching rows is less than or equal to the maxRetrieve value (in the Util.ARGetListSQL class. Specify NULL for this parameter if you do not want to retrieve this count.

Note: Performing this count requires additional search time if the number of matching rows is more than the maxRetrieve value (in the Util.ARGetListSQL class. In this case, the cost of completing the search diminishes the performance benefits of retrieving fewer rows.

getContents

public Value[][] getContents()

Returns list of zero or more (accessible) rows that match the criteria defined by the sqlCommand value (in the Util.ARGetListSQL class. Each item in the list represents one matching row, each of which contains a list of the selected column values. The system returns a list with zero items if no rows match the specified criteria.