Click or drag to resize

AXSQLADT Class

X#
This class allows to open the proprietry ADT format with SQL Syntax using the Advantage driver
Inheritance Hierarchy
Object
  Workarea
    ADSRDD
      AXSQLRDD
        AXSQLADT
          AXSQLADT

Namespace:  Advantage
Assembly:  XSharp.Rdd (in XSharp.Rdd.dll) Version: 2.21
Syntax
 CLASS AXSQLADT INHERIT AXSQLADT
Request Example View Source

The AXSQLADT type exposes the following members.

Constructors
  NameDescription
Public methodAXSQLADT
Initializes a new instance of the AXSQLADT class
Top
Properties
  NameDescription
Public property_RecNo (Inherited from ADSRDD.)
Public propertyACEConnectionHandle (Inherited from ADSRDD.)
Public propertyACEIndexHandle (Inherited from ADSRDD.)
Public propertyACESQLStatementHandle (Inherited from AXSQLRDD.)
Public propertyACETableHandle (Inherited from ADSRDD.)
Public propertyAlias
Retrieve the alias name.
(Inherited from Workarea.)
Public propertyArea
Retrieve the Workarea number.
(Inherited from Workarea.)
Public propertyBoF
Is the table at the logical beginning-of-file.
(Inherited from Workarea.)
Public propertyBottom
Is at bottom ?
(Inherited from Workarea.)
Public propertyClosed
Has the workarea been closed.
(Inherited from Workarea.)
Public propertyDeleted
Is the current row deleted?
(Inherited from ADSRDD.)
Public propertyDriver (Inherited from ADSRDD.)
Public propertyEoF
Is the table at the logical end-of-file.
(Inherited from Workarea.)
Public propertyExclusive
Is the Workarea opened Exclusively
(Inherited from Workarea.)
Public propertyFieldCount
The # of fields in the current Workarea.
(Inherited from Workarea.)
Public propertyFileName
File name of the main file
(Inherited from Workarea.)
Public propertyFilterInfo
Current Filter
(Inherited from Workarea.)
Public propertyFilterText
The filter condition as a string.
(Inherited from Workarea.)
Public propertyFound
The outcome of the last search operation.
(Inherited from ADSRDD.)
Public propertyHasProperties
Does the workarea have properties.
(Inherited from Workarea.)
Public propertyHasRelations
Does the workarea have relations.
(Inherited from Workarea.)
Public propertyMemo
Current memo implementation.
(Inherited from Workarea.)
Public propertyOrderCondInfo
Current Order condition
(Inherited from Workarea.)
Public propertyProperties (Inherited from Workarea.)
Public propertyReadOnly
Is the file opened ReadOnly ?
(Inherited from Workarea.)
Public propertyRecCount (Inherited from ADSRDD.)
Public propertyRecId
The row identifier at the current cursor position.
(Inherited from Workarea.)
Public propertyRecNo (Inherited from ADSRDD.)
Public propertyRecordBuffer
Current Record
(Inherited from Workarea.)
Public propertyShared
Is the current Workarea opened Shared?
(Inherited from Workarea.)
Public propertyTop
Is at top?
(Inherited from Workarea.)
Top
Methods
  NameDescription
Public method_getMemoBlockNumber (Inherited from Workarea.)
Public methodAddField (Inherited from ADSRDD.)
Public methodAppend
Append a blank row and position the cursor to the new row.
(Inherited from ADSRDD.)
Public methodAppendLock
This method is not supported by the AdsRDD class
(Inherited from ADSRDD.)
Public methodBlobInfo
This method is not supported by the AdsRDD class
(Inherited from ADSRDD.)
Public methodChildEnd
Report the initialization of a relation.
(Inherited from Workarea.)
Public methodChildStart
Report the initialization of a relation.
(Inherited from Workarea.)
Public methodChildSync
Post a pending relational movement, indicating that the specified child work area has been affected by a parental movement.
(Inherited from Workarea.)
Public methodClearFilter
Clear the active filter condition.
(Inherited from ADSRDD.)
Public methodClearRel
Clear relations.
(Inherited from ADSRDD.)
Public methodClearScope
Clear the active locate condition.
(Inherited from Workarea.)
Public methodClose
Close a table.
(Inherited from AXSQLRDD.)
Public methodCloseMemFile
Close the memo file
(Inherited from Workarea.)
Public methodCompile
Compile an expression.
(Inherited from Workarea.)
Public methodContinue
Goto the next record based on the corrent locate condition.
(Inherited from Workarea.)
Public methodCreate
Create a table.
(Inherited from ADSRDD.)
Public methodCreateFields
Add columns defined in an array.
(Inherited from Workarea.)
Public methodCreateMemFile
Create the memo file
(Inherited from Workarea.)
Public methodDbEval
Evaluate a code block for each row.
(Inherited from Workarea.)
Public methodDelete (Inherited from ADSRDD.)
Public methodDispose (Inherited from Workarea.)
Public methodDispose(Logic) (Inherited from Workarea.)
Public methodEvalBlock
Evaluate a code block.
(Inherited from Workarea.)
Public methodEvalFilter (Inherited from Workarea.)
Public methodFieldIndex
Return the ONE based field index for a field name.
(Inherited from Workarea.)
Public methodFieldInfo
Retrieve and optionally change information about a column.
(Inherited from ADSRDD.)
Public methodFieldName
Retrieve a column name based on its ONE based column number.
(Inherited from Workarea.)
Public methodFlush
Flush the changes to the table, its indexes and memo file.
(Inherited from ADSRDD.)
Public methodForceRel
This method is not supported by the AdsRDD class
(Inherited from ADSRDD.)
Public methodGetField
Return the (1 based) RddFieldInfo object for the specified field
(Inherited from Workarea.)
Public methodGetRec
This method is not supported by the AdsRDD class
(Inherited from ADSRDD.)
Public methodGetScope
Retrieve the active locate condition.
(Inherited from Workarea.)
Public methodGetValue (Inherited from ADSRDD.)
Public methodGetValueFile
This method is not supported by the AdsRDD class
(Inherited from ADSRDD.)
Public methodGetValueLength
Get the length of the for the specified column.
(Inherited from Workarea.)
Public methodGoBottom
Position the cursor to the last logical row.
(Inherited from ADSRDD.)
Public methodGoCold
Write the contents of a work area's memory to the data store (usually a disk).
(Inherited from ADSRDD.)
Public methodGoHot
Mark a data buffer as hot, indicating that it needs to be written to the data store.
(Inherited from ADSRDD.)
Public methodGoTo
Position the cursor to a specific, physical row.
(Inherited from ADSRDD.)
Public methodGoToId
Position the cursor to a specific, physical identity.
(Inherited from ADSRDD.)
Public methodGoTop
Position the cursor to the first logical row.
(Inherited from ADSRDD.)
Public methodHeaderLock
This method is not supported by the AdsRDD class
(Inherited from ADSRDD.)
Public methodInfo
Retrieve and optionally change information about a work area.
(Inherited from AXSQLRDD.)
Public methodLock
Perform a lock.
(Inherited from ADSRDD.)
Public methodOpen
Open a table.
(Inherited from AXSQLRDD.)
Public methodOpenMemFile
Open the memo file
(Inherited from Workarea.)
Public methodOrderCondition
Set the condition for the next Index Creation
(Inherited from Workarea.)
Public methodOrderCreate
Create a new index or tag.
(Inherited from Workarea.)
Public methodOrderDestroy
Delete an index or tag.
(Inherited from Workarea.)
Public methodOrderInfo
Retrieve information about an index.
(Inherited from Workarea.)
Public methodOrderListAdd
Open an index file and add to the list of open indexes for the current Workarea.
(Inherited from Workarea.)
Public methodOrderListDelete
Close an index file and remove it from the list of open indexes for the current Workarea.
(Inherited from Workarea.)
Public methodOrderListFocus
Set focus to another index in the list open indexes for the current Workarea.
(Inherited from Workarea.)
Public methodOrderListRebuild
Rebuild all indexes for the current Workarea.
(Inherited from Workarea.)
Public methodPack (Inherited from ADSRDD.)
Public methodPutRec
This method is not supported by the AdsRDD class
(Inherited from ADSRDD.)
Public methodPutValue (Inherited from ADSRDD.)
Public methodPutValueFile
This method is not supported by the AdsRDD class
(Inherited from ADSRDD.)
Public methodRecall (Inherited from ADSRDD.)
Public methodRecInfo
Retrieve and optionally change information about a row.
(Inherited from AXSQLRDD.)
Public methodRecordMovement (Inherited from ADSRDD.)
Public methodRefresh
Discard all changes to the current record and reread the buffer from disk. When the current buffer is in Append mode then the server will move to the bottom of the file.
(Inherited from ADSRDD.)
Public methodRelArea
Retrieve the logical number of a related work area.
(Inherited from Workarea.)
Public methodRelEval
Evaluate a code block against the relation in a work area.
(Inherited from Workarea.)
Public methodRelText
Retrieve the key expression of a relation.
(Inherited from Workarea.)
Public methodSeek
Perform a seek operation on the current selected index for the current Workarea.
(Inherited from Workarea.)
Public methodSetFieldExtent (Inherited from ADSRDD.)
Public methodSetFilter
Set the filter condition.
(Inherited from ADSRDD.)
Public methodSetParameters (Inherited from AXSQLRDD.)
Public methodSetRel
Set a relation.
(Inherited from ADSRDD.)
Public methodSetScope
Set the locate condition.
(Inherited from Workarea.)
Public methodSkip
Position the cursor relative to its current position.
(Inherited from ADSRDD.)
Public methodSkipFilter
Position the cursor, respecting scope and filter conditions.
(Inherited from ADSRDD.)
Public methodSkipRaw
Position the cursor regardless of scope and filter conditions.
(Inherited from ADSRDD.)
Public methodSkipScope
Position the cursor relative to its current position within the current scope.
(Inherited from Workarea.)
Public methodSort
This method is not supported by the AdsRDD class
(Inherited from ADSRDD.)
Public methodSyncChildren
Force relational movement in child work areas to synchronize them with the parent work area.
(Inherited from Workarea.)
Public methodTrans
Copy one or more rows from one work area to another.
(Inherited from ADSRDD.)
Public methodTransRec
Copy a single row from one work area to another.
(Inherited from ADSRDD.)
Public methodUnLock
Release locks.
(Inherited from ADSRDD.)
Public methodZap
Physically remove all rows from a table.
(Inherited from ADSRDD.)
Top
Fields
  NameDescription
Public field_Fields
List of Fields
(Inherited from Workarea.)
Public field_hStatement (Inherited from AXSQLRDD.)
Top
See Also