Methods

Description

Close() As String

Close a result set

ExecSQL() As String

Execute a SQL statement that does not return a result. e.g. UPDATE or INSERT INTO

FieldByName(ByVal sVal As String) As Object

Return the value of a field. e.g. mySQLTable.FieldbyName("LAST") will return the contents of the LAST field.

GetParamBoolean(ByVal pName As String) As Short

GetParamFloat(ByVal pName As String) As Double

GetParamInteger(ByVal pName As String) As Integer

GetParamString(ByVal pName As String) As String

MoveBy(ByVal iMove As Integer)

Traverse "iMove" records

MoveFirst()

Go to the first record in the result set.

MoveLast()

Go to the last record in the result set.

Open() As String

Execute a SQL statement that returns a result. e.g. SELECT

ReadRecord()

Read the entire record buffer after a result set has been retrieved

SetParamBoolean(ByVal pName As String, ByVal bVal As Short)

SetParamFloat(ByVal pName As String, ByVal bVal As Double)

SetParamInteger(ByVal pName As String, ByVal pVal As Integer)

SetParamString(ByVal pName As String, ByVal pVal As String)

Version() As String

Returns current Apollo .NET version