LibMyWitch Recordset Object

• AbsolutePosition property
• BOF property
• EOF property
• Fields property
• GetRows method
• MoveFirst method
• MoveLast method
• MoveNext method
• MovePrevious method
• RecordCount property
• ValueByCol method
• ValueByName method

AbsolutePosition property

property MyWitch_Recordset.AbsolutePosition As long

Returns or sets the position of a recordset

Returns or sets the position of a recordset's current record from 1 to RecordCount.

BOF property

property MyWitch_Recordset.BOF As boolean

Indicates whether or not a cursor is positioned at the first record in a dataset.

EOF property

property MyWitch_Recordset.EOF As boolean

Indicates whether or not a cursor is positioned at the last record in a dataset.

Fields property

property MyWitch_Recordset.Fields As MyWitch_Fields

Reference to MyWitch_Fields object.

GetRows method

method MyWitch_Recordset.GetRows(Optional bShowBlobs,Optional bShowHeader)

Returns complete dataset within a variant array

MoveFirst method

method MyWitch_Recordset.MoveFirst()

Sets pointer to first recordset

MoveLast method

method MyWitch_Recordset.MoveLast()

Sets pointer to last recordset

MoveNext method

method MyWitch_Recordset.MoveNext()

Sets pointer to next recordset

MovePrevious method

method MyWitch_Recordset.MovePrevious()

Sets pointer to previous recordset

RecordCount property

property MyWitch_Recordset.RecordCount As long

Returns count of records

ValueByCol method

method MyWitch_Recordset.ValueByCol(Index) as string

Returns value of the column of current record

This method is faster then the use of the Fields object

ValueByName method

method MyWitch_Recordset.ValueByName(ColName,optional TableName) as string

Returns value of the column of current record