Click or drag to resize

CoreDb Class

X#
The CoreDb class contains the methods to manipulate Workareas.
The class is stateless. The Workarea state is stored in the RuntimeState.
Inheritance Hierarchy
Object
  CoreDb
    VoDb

Namespace:  XSharp
Assembly:  XSharp.Core (in XSharp.Core.dll) Version: 2.19
Syntax
 CLASS CoreDb
Request Example View Source

The CoreDb type exposes the following members.

Constructors
  NameDescription
Public methodCoreDb
Initializes a new instance of the CoreDb class
Top
Methods
  NameDescription
Public methodStatic member_ErrInfoPtr
Return exception object from last RDD operation.
Public methodStatic memberAlias
Return the alias of a specified work area as a string.
Public methodStatic memberAppend
Add a new record.
Public methodStatic memberBlobInfo(DWord, DWord, Object)
Retrieve information about a memo column.
Public methodStatic memberBlobInfo(DWord, DWord, Object)
Retrieve information about a memo column.
Public methodStatic memberBof
Determine when beginning-of-file is encountered.
Public methodStatic memberBuffRefresh
Refresh the buffer for the current Workarea, discarding any changes that were made.
Public methodStatic memberClearFilter
Clear a logical filter condition.
Public methodStatic memberClearLocate
Clear a locate condition by deleting the locate code block.
Public methodStatic memberClearRelation
Clear any active relations.
Public methodStatic memberClearScope
Clear the active locate condition.
Public methodStatic memberCloseAll
Close all files in all work areas.
Public methodStatic memberCloseArea
Close all files in a work area.
Public methodStatic memberCommit
Flush pending updates in one work area.
Public methodStatic memberCommitAll
Flush pending updates in all work areas.
Public methodStatic memberContinue
Resume a pending locate condition.
Public methodStatic memberCreate(String, RddFieldInfo, String, Logic, String, String, Logic, Logic)
Create new file through the specified RDDs
Public methodStatic memberCreate(String, RddFieldInfo, Type, Logic, String, String, Logic, Logic)
Create new file through the specified RDDs
Public methodStatic memberCreate(String, RddFieldInfo, _RddList, Logic, String, String, Logic, Logic)
Create new file through the specified RDDs
Public methodStatic memberDbf
Return the name of the alias.
Public methodStatic memberDelete
Mark the current record for deletion.
Public methodStatic memberDeleted
Return the deleted status of the current record.
Public methodStatic memberEof
Determine when end-of-file is encountered.
Public methodStatic memberEval
Evaluate a code block for each record that matches a specified scope and/or condition.
Public methodStatic memberFCount
Return the number of fields in the current Workarea
Public methodStatic memberFieldGet
Retrieve the value of a specified database field.
Public methodStatic memberFieldGetBytes
Retrieve the value of a specified database field as an array of bytes
Public methodStatic memberFieldInfo(DWord, DWord, Object)
Retrieve and optionally change information about a column.
Public methodStatic memberFieldInfo(DWord, DWord, Object)
Retrieve and optionally change information about a column.
Public methodStatic memberFieldName
Return the name of a field as a string.
Public methodStatic memberFieldPos
Return the position of a field.
Public methodStatic memberFieldPut
Set the value of a specified database field.
Public methodStatic memberFieldPutBytes
Retrieve the value of a specified database field as an array of bytes
Public methodStatic memberFileGet
Import contents from file into Memo field
Public methodStatic memberFilePut
Export field contents from Memo field to file
Public methodStatic memberFilter
Return a filter.
Public methodStatic memberFlock
Lock an opened and shared database file.
Public methodStatic memberFound
Determine if the previous search operation succeeded.
Public methodStatic memberGetScope
Gets the locate condition.
Public methodStatic memberGetSelect
Return the work area number.
Public methodStatic memberGoBottom
Move to the last logical record.
Public methodStatic memberGoto
Move to a record specified by record number.
Public methodStatic memberGoTop
Move to the first logical record.
Public methodStatic memberHeader
Public methodStatic memberInfo(DWord, Object)
Retrieve information about a work area.
Public methodStatic memberInfo(DWord, Object)
Retrieve information about a work area.
Public methodStatic memberJoinAppend
Write values to destination Workarea in a JOIN operation
Public methodStatic memberLastRec
Return the number of the last record in a database file.
Public methodStatic memberLocate
Search for the first record that matches a specified condition and scope.
Public methodStatic memberMemoExt
Return Memo File extension
Public methodStatic memberOrdBagExt
Return the default index file extension for a work area as defined by the its RDD.
Public methodStatic memberOrdCondSet
Set the condition and scope for an order.
Public methodStatic memberOrdCreate
Create or replace an order in an index file.
Public methodStatic memberOrdDestroy
Remove an order from an open index file.
Public methodStatic memberOrderInfo(DWord, String, Object, Object)
Return information about index files and the orders in them.
Public methodStatic memberOrderInfo(DWord, String, Object, Object)
Return information about index files and the orders in them.
Public methodStatic memberOrdListAdd
Open an index file and add specified orders to the order list in a work area.
Public methodStatic memberOrdListClear
Remove orders from the order list in a work area and close associated index files.
Public methodStatic memberOrdListRebuild
Rebuild all orders in the order list of a work area.
Public methodStatic memberOrdSetFocus(String, Object)
Set the controlling order for a work area.
Public methodStatic memberOrdSetFocus(String, Object, String)
Set the controlling order for a work area.
Public methodStatic memberPack
Remove all records that have been marked for deletion from a database file.
Public methodStatic memberRddCount
Public methodStatic memberRddInfo(DWord, Object)
Return and optionally change settings controlled directly by the RDD.
Public methodStatic memberRddInfo(DWord, Object)
Return and optionally change settings controlled directly by the RDD.
Public methodStatic memberrddList
Returns list of RDD names that are in use at this moment
Public methodStatic memberrddList(_RddList, DWord) Obsolete.
Public methodStatic memberRddName
Return an RDD name.
Public methodStatic memberRddSetDefault
Return and optionally change the default RDD for the application.
Public methodStatic memberRecall
Restore the current record if it is marked for deletion.
Public methodStatic memberRecNo
Return the current record number.
Public methodStatic memberRecordGet
Get the contents of the current record as an array of bytes
Public methodStatic memberRecordInfo(DWord, Object, Object)
Retrieve information about a record.
Public methodStatic memberRecordInfo(DWord, Object, Object)
Retrieve information about a record.
Public methodStatic memberRecordPut
Update the current record from an array of bytes
Public methodStatic memberRecSize
Return the record length in the current Workarea
Public methodStatic memberRefresh
Discard all the changes to the current workares
Public methodStatic memberRelation
Return the linking expression of a specified relation.
Public methodStatic memberRLock
Lock the current record.
Public methodStatic memberRSelect
Return the work area number of a relation.
Public methodStatic memberSeek
Move to the record having the specified key value.
Public methodStatic memberSelect
Select a new work area and retrieve the current work area.
Public methodStatic memberSetFilter
Set a filter condition.
Public methodStatic memberSetFound
Set the found flag.
Public methodStatic memberSetLocate
Specify the code block for a locate condition.
Public methodStatic memberSetRelation
Relate a specified work area to the current work area.
Public methodStatic memberSetScope
Set the locate condition.
Public methodStatic memberSetSelect
Select a new work area.
Public methodStatic memberSkip
Move the record pointer relative to the current record.
Public methodStatic memberSkipScope
Position the cursor relative to its current position within the current scope.
Public methodStatic memberSort
Copy records to a database file in sorted order.
Public methodStatic memberSymSelect
Select a new work area by specifying its alias as a string and return the number of the current work area.
Public methodStatic memberTrans
Copy one or more rows from one work area to another.
Public methodStatic memberTransRec
Copy a single row from one work area to another.
Public methodStatic memberUnlock
Release all locks for a work area.
Public methodStatic memberUnlockAll
Release all locks for all work areas.
Public methodStatic memberUseArea(Logic, String, String, String, Logic, Logic)
Open a database file.
Public methodStatic memberUseArea(Logic, Type, String, String, Logic, Logic)
Open a database file.
Public methodStatic memberUseArea(Logic, _RddList, String, String, Logic, Logic)
Open a database file.
Public methodStatic memberZap
Remove all records from the current Workarea.
Top
Events
  NameDescription
Public eventStatic memberNotify
An event to which you can subscribe to be notified of operations on Workareas.
Top
See Also