PSCursorClass

Provides access to a SQL result set.

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

GetColumnLength

Retrieves the length of a column in a cursor

GetColumnName

Retrieves the name of a column in a cursor

GetColumnType

Retrieves the SQL type of a column in a cursor

GetColumnTypeName

Retrieves the database-specific type of a column in a cursor

GetPrecision

Retrieves the number of decimal digits of a column in a cursor

GetResultSet

Retrieves the result set for a cursor

GetResultSetMetaData

Retrieves the metadata result set

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

GetValue

Obsolete method that was previously used for PowerDynamo or 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