Table Object

<< Click to Display Table of Contents >>

Navigation:  Apollo COM > Using Apollo COM >

Table Object

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

Properties

AccessMethod: WideString (amLocal or amServer)

Active: WordBool

ActiveIndexName: WideString

ApolloConnection: OleVariant (amServer mode only) (not supported yet)

Bof: WordBool readonly

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

DatabaseName: WideString

Eof: WordBool readonly

Exclusive: WordBool

FetchCount: Integer (amServer mode only)

GroupName: WideString (amServer mode only)

Host: WideString (amServer mode only)

Password: WideString (amServer mode only)

Port: Integer (amServer mode only)

ReadOnly: WordBool

ServerName: WideString (amServer mode only)

TableName: WideString

TableType: WideString

TurboRead: WordBool

User: WideString (amServer mode only)

WA: Integer

 

Methods

AddDudenCollation

AddEtecCollation

Alias(uiWorkArea: Integer): WideString

Append

AppendBlank

AppendFrom(const cpFileName: WideString iSourceType: Smallint const cpScopeExpr: WideString): WordBool

BaseDate: WideString

BaseName: WideString

BlobToFile(const cpFieldName: WideString const cpFileName: WideString): WordBool

Close

CloseAll

CloseIndexes

Commit

CopyFile(const cpToFileName: WideString): WordBool

CopyFileText(const cpTextFileName: WideString iFileType: Smallint): WordBool

CopyStructure(const cpFileName: WideString const cpAlias: WideString): WordBool

CopyStructureExtended(const cpFileName: WideString): WordBool

Count: Integer

CreateExec: WordBool

CreateField(const cpName: WideString const cpType: WideString iLength: Smallint iDecimals: Smallint)

CreateFrom(const cpFileName: WideString const cpAlias: WideString const cpStruFile: WideString iRDEType: Smallint): WordBool

CreateNew(const cpFileName: WideString const cpAlias: WideString iRDEType: Smallint iNumFields: Smallint): Smallint

DbfDecrypt: WordBool

DbfEncrypt: WordBool

DBFilter: WideString

DBRLockList(const ulpArray: WideString)

Decrypt(const cpBuffer: WideString const cpPassword: WideString iLen: Integer): WideString

Delete

Deleted: WordBool

DeleteFile(const sFileName: WideString): WordBool

Descend(const cpKeyString: WideString): WideString

Edit

Empty(const cpFieldName: WideString): WordBool

Encrypt(const cpBuffer: WideString const cpPassword: WideString iLen: Integer): WideString

ErrorLevel(iErrorLevel: Smallint): Smallint

EvalLogical(const cpExpression: WideString): WordBool

EvalNumeric(const cpExpression: WideString): Double

EvalString(const cpExpression: WideString): WideString

EvalTest(const cpExpression: WideString): Integer

FieldCount: Integer

FieldDecimals(const cpFieldName: WideString): Integer

FieldName(uiFieldNum: Integer): WideString

FieldNum(const cpFieldName: WideString): Integer

FieldOffSet(const cpFieldName: WideString): Integer

FieldType(const cpFieldName: WideString): WideString

FieldWidth(const cpFieldName: WideString): Integer

FileExists(const cpFileName: WideString): WordBool

FilterAlias

FilterDlg

First

FLock: WordBool

Found: WordBool

GetBlob(const cpFieldName: WideString var vpVar: OleVariant): Integer

GetBlobLength(const cpFieldName: WideString): Integer

GetByte(const cpFieldName: WideString): WideString

GetDateJulian(const cpFieldName: WideString): Integer

GetDateString(const cpFieldName: WideString): WideString

GetDateTime(const cpFieldName: WideString): Double

GetDouble(const cpFieldName: WideString): Double

GetInteger(const cpFieldName: WideString): Smallint

GetLogical(const cpFieldName: WideString): WordBool

GetLong(const cpFieldName: WideString): Integer

GetMemo(const cpFieldName: WideString uiLineWidth: Integer): WideString

GetQueryBit(lRecNo: Integer): WordBool

GetRecord(var cpRecord: WideString)

GetScope(iWhichScope: Smallint): WideString

GetString(const cpFieldName: WideString): WideString

GetTrimString(const cpFieldName: WideString): WideString

Go(lRecNum: Integer)

GoBottom

GoTop

Index(const cpFileName: WideString const cpExpr: WideString iOption: Smallint bDescend: WordBool const cpCondition: WideString): SYSINT

IndexClose

IndexCondition: WideString

IndexFlip: WordBool

IndexKey: WideString

IndexKeyField: WideString

IndexName(iIndex: Smallint): WideString

IndexOpen(const cpFileName: WideString): SYSINT

IndexOrd: Smallint

IndexTag(const cpFileName: WideString const cpTagName: WideString const cpExpr: WideString iOption: Integer bDescend: WordBool const cpCondition: WideString): SYSINT

IndexType: Smallint

IsEncrypted(iFileOrRec: Smallint): WordBool

KeyAdd(const cpTagName: WideString): WordBool

KeyData: WideString

KeyDrop(const cpTagName: WideString): WordBool

Last

Locate(const cpExpression: WideString iDirection: WordBool bContinue: WordBool): Integer

LockCount: Integer

Locked(lRecNum: Integer): WordBool

MemDealloc(vpPtr: Integer)

MoveBy(lRecNum: Integer)

Next

Open

OpenMode: Smallint

OrderPosGet: Double

OrderPosSet(dPosition: Double)

OrderRecNo: Integer

Pack

Post

Prior

PutBlob(const cpFieldName: WideString var vpData: OleVariant iSize: Integer): Integer

PutDateString(const cpFieldName: WideString const pVal: WideString)

PutDouble(const cpFieldName: WideString dVal: Double)

PutInteger(const cpFieldName: WideString iVal: Integer)

PutLogical(const cpFieldName: WideString bVal: WordBool)

PutLong(const cpFieldName: WideString iVal: Integer)

PutMemo(const cpFieldName: WideString const vpData: WideString)

PutRecord(const cpRecord: WideString)

PutString(const cpFieldName: WideString const pVal: WideString)

Query(const cpExpression: WideString): Integer

QueryRecCount: Integer

QueryTest(const cpExpression: WideString): Smallint

Recall

RecCount: Integer

RecNo: Integer

RecSize: Integer

Reindex

Replace(const cpFieldName: WideString iDataType: Smallint vpData: OleVariant)

Rlock(lRecNum: Integer): WordBool

RYOFilterActivate(iFilterHandle: Smallint iBoolOperation: Smallint): WordBool

RYOFilterCopy: Smallint

RYOFilterCreate: Smallint

RYOFilterDestroy(iFilterHandle: Smallint): WordBool

RYOFilterRestore(const cpFileName: WideString): WordBool

RYOFilterSave(iFilterHandle: Smallint const cpFileName: WideString): WordBool

RYOFilterSetBit(iFilterHandle: Smallint lRecNo: Integer iOnOrOff: Smallint): WordBool

RYOKeyAdd(const cpTagName: WideString const cpKey: WideString): WordBool

RYOKeyDrop(const cpTagName: WideString): WordBool

Seek(const cpKeyValue: WideString): WordBool

SeekBin(const cpKeyValue: WideString uiLength: Integer): WordBool

Select(uiBaseArea: Integer): Integer

SetCentury(uiOnOff: WordBool)

SetDeleted(uiOnOff: WordBool)

SetExact(uiOnOff: WordBool)

SetFilter(const cpExpression: WideString)

SetGaugeFunc(pFunc: Integer)

SetGaugeHook(hwndGauge: Integer)

SetMachineCollation

SetOrder(iIndex: Smallint): Smallint

SetPassword(const cpEncodeKey: WideString)

SetQueryBit(lRecNo: Integer bValue: WordBool)

SetRelation(uiChildArea: Integer const cpKeyExpr: WideString)

SetScope(const cpLowVal: WideString const cpHighVal: WideString): OleVariant

SetSoftSeek(uiOnOff: WordBool)

SetStringType(uiStringType: Integer)

SetSystemCollation

SetTurboRead(uiOnOff: WordBool)

Skip(lNumRecs: Integer)

SysProp(uiSysItem: Integer var vpData: OleVariant): Integer

TagArea(const cpTagName: WideString): Smallint

TagName(iTagArea: Smallint): WideString

Translate(uiOnOff: WordBool)

Unlock(lRecNum: Integer)

Use(const cpFileName: WideString const cpAlias: WideString iOpenMode: Smallint iRDEType: Smallint): Smallint

Version: WideString

WorkArea(const cpAlias: WideString): Integer

Zap