SQLTable Properties

<< Click to Display Table of Contents >>

Navigation:  Apollo .NET (API Reference) >

SQLTable Properties

 

Properties

Description

AccessMethod() As TAccessMethod

Setting for local or client/server.

amLocal for local or peer-to-peer data access

amServer for connecting to an Apollo Server (client/server)

ApolloConnection() As TApolloConnection

Reference to object that manages which data engine the Apollo client will connect to. See TApolloConnection

BOF() (ReadOnly)

True if positioned at the beginning of the file.

DatabaseName() As String

Database or Alias name

EOF() (ReadOnly)

True if positioned at the end of the file.

FieldCount() (ReadOnly)

Number of fields

FieldName(ByVal iVal As Integer) (ReadOnly)

Name of the nth field

FieldType(ByVal iVal As Integer) (ReadOnly)

Data type of the nth field

FieldWidth(ByVal iVal As Integer) (ReadOnly)

Size or width of the nth field

RecordCount() (ReadOnly)

Number of records returned in the result set.

RecordNo() (ReadOnly)

Current record #

RecordSize() (ReadOnly)

Size of the record

SQL()

The SQL statement to run. Can be any valid SQL statement