All Packages  Class Hierarchy  This Package  Previous  Next  Index

Class msql.MsqlResult

java.lang.Object
   |
   +----msql.MsqlResult

public class MsqlResult
extends Object
Object containing the results of a select query. A combination of two MsqlData instances representing the retrieved data and a description of the fields which make up the data.


Constructor Index

 o MsqlResult(MsqlData, MsqlData)
Constructor - Accepts row and field info as arguments

Method Index

 o _FetchField()
Fetch the field from the table
 o DataSeek(int)
Data Seek
 o FetchField()
Fetch the next field from the list of fields
 o FetchRow()
Fetch the next row from the table
 o FieldSeek(int)
Field Seek
 o ListFields()
Return reference to array of field descriptions.
 o NumFields()
Return number of fields in table
 o NumRows()
Return number of rows in table

Constructors

 o MsqlResult
 public MsqlResult(MsqlData table,
                   MsqlData fields)
Constructor - Accepts row and field info as arguments

Parameters:
table - instance of MsqlData representing the data set.
fields - instance of MsqlData containing field information.

Methods

 o FetchRow
 public String[] FetchRow()
Fetch the next row from the table

Returns:
an array of Strings representing the columns of the row.
 o _FetchField
 public String[] _FetchField()
Fetch the field from the table

Returns:
an array of Strings representing the columns of the row.
 o FetchField
 public MsqlFieldDesc FetchField()
Fetch the next field from the list of fields

Returns:
an array of Strings representing the Name, Type, Length Non-null flag and key flag of the next field.
 o ListFields
 public MsqlFieldDesc[] ListFields()
Return reference to array of field descriptions.

Returns:
an array of MsqlFieldDesc.
 o NumRows
 public int NumRows()
Return number of rows in table

Returns:
the number of rows in this data set.
 o NumFields
 public int NumFields()
Return number of fields in table

Returns:
the number of fields in this data set.
 o DataSeek
 public void DataSeek(int i)
Data Seek

Parameters:
i - the index of the row to be retrieved.
 o FieldSeek
 public void FieldSeek(int i)
Field Seek

Parameters:
i - the index of the field to be retrieved.

All Packages  Class Hierarchy  This Package  Previous  Next  Index