PSCursorClass

Provides access to a SQL result set.

For JSP targets you must assign a variable of the PSCursorClass type before you can create an instance of the object or call methods on it. To create an object of type PSCursorClass in ASP targets, you can designate an untyped variable to reference an instance of the object that is returned by the CreateCursor method on a PSConnectionClass object.

Syntax

PSCursorClass( ResSet )

Constructors

PSCursorClass constructor	Datatype	Description
ResSet	ResultSet	Result set object returned by the SQL query

Methods

PSCursorClass method	Description
EOF	Determines whether the end of a cursor has been reached
GetColumnCount	Retrieves the number of columns in a cursor
GetColumn<DataType>	Retrieves the value of a column in a cursor (JSP targets)
GetColumnLength	Retrieves the length of a column in a cursor (JSP targets)
GetColumnName	Retrieves the name of a column in a cursor (JSP targets)
GetColumnType	Retrieves the SQL type of a column in a cursor (JSP targets)
GetColumnTypeName	Retrieves the database-specific type of a column in a cursor (JSP targets)
GetPrecision	Retrieves the number of decimal digits of a column in a cursor (JSP targets)
GetResultSet	Retrieves the result set for a cursor (JSP targets)
GetResultSetMetaData	Retrieves the metadata result set (JSP targets)
GetRowCount	Retrieves the number of rows in a cursor
GetScale	Retrieves the number of digits to right of the decimal point for a column in a cursor (JSP targets)
GetValue	Retrieves the value of a column in a cursor (ASP targets)
Move	Moves to an absolute row in a cursor
MoveFirst	Moves to the first row in a cursor
MoveLast	Moves to the last row in a cursor
MoveNext	Moves to the next row in a cursor
MovePrevious	Moves to the previous row in a cursor