Query Object

<< Click to Display Table of Contents >>

Navigation:  Apollo COM > Using Apollo COM >

Query Object

See the C:\Program Files\Apollo7\Help\ApolloSQL7.CHM help file for a description of each method.

Properties

AccessMethod: WideString (amLocal or amServer)

Active: WordBool readonly

Bof: WordBool readonly

CommitLevel: WideString (clNone – fastest, clNormal, clFull – slowest)

DatabaseName: WideString

Eof: WordBool readonly

ErrorMsg: WideString

ErrorNo: Integer

FetchCount: Integer

GroupName: WideString (amServer mode only)

Host: WideString (amServer mode only)

Password: WideString (amServer mode only)

Port: Integer (amServer mode only)

RecCount: Integer readonly

RecNo: Integer

ServerName: WideString (amServer mode only)

SetDeleted: WordBool

SQL: WideString

User: WideString

 

Methods

AddDudenCollation

AddEtecCollation

ClearTables

Close

ExecSQL

FieldByName(const Param1: WideString): OleVariant

Fields(Param1: Integer): OleVariant

First

GetParamBoolean(const Param1: WideString): WordBool

GetParamDate(const Param1: WideString): WideString

GetParamFloat(const Param1: WideString): Double

GetParamInteger(const Param1: WideString): Integer

GetParamString(const Param1: WideString): WideString

Last

MoveBy(Param1: Integer)

MoveFirst

MoveLast

MovePrevious

Next

Open

Prior

SetMachineCollation

SetParamBoolean(const Param: WideString Value: WordBool)

SetParamDate(const Param: WideString const Value: WideString)

SetParamFloat(const Param: WideString Value: Double)

SetParamInteger(const Param: WideString Value: Integer)

SetParamString(const Param: WideString const Value: WideString)

SetSystemCollation

SetTables(const TableName: WideString const Alias: WideString const TableType: WideString const Password: WideString Translate: WordBool const ExtraIndexes: WideString)

Version: WideString