Class MsqlResult

java.lang.Object
   |
   +----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.

Constructors

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

Methods

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

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

 FetchRow 
 public String[] FetchRow()
Fetch the next row from the table
Returns:
an array of Strings representing the columns of the row.
 _FetchField 
 public String[] _FetchField()
Fetch the field from the table
Returns:
an array of Strings representing the columns of the row.
 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.
 ListFields 
 public MsqlFieldDesc[] ListFields()
Return reference to array of field descriptions.
Returns:
an array of MsqlFieldDesc.
 NumRows 
 public int NumRows()
Return number of rows in table
Returns:
the number of rows in this data set.
 NumFields 
 public int NumFields()
Return number of fields in table
Returns:
the number of fields in this data set.
 DataSeek 
 public void DataSeek(int i)
Data Seek
Parameters:
i - the index of the row to be retrieved.
 FieldSeek 
 public void FieldSeek(int i)
Field Seek
Parameters:
i - the index of the field to be retrieved.