CoreDb Class |  |
The CoreDb class contains the methods to manipulate Workareas.
The class is stateless. The Workarea state is stored in the RuntimeState.
The class is stateless. The Workarea state is stored in the RuntimeState.
Inheritance HierarchyNamespace: XSharp
Assembly: XSharp.Core (in XSharp.Core.dll) Version: 2.21
SyntaxThe CoreDb type exposes the following members.
ConstructorsMethods| Name | Description | |
|---|---|---|
  | _ErrInfoPtr | Return exception object from last RDD operation. |
| Alias |
Return the alias of a specified work area as a string.
|
| Append |
Add a new record.
|
| BlobInfo(DWord, DWord, Object) | Retrieve information about a memo column. |
| BlobInfo(DWord, DWord, Object) | Retrieve information about a memo column. |
| Bof |
Determine when beginning-of-file is encountered.
|
| BuffRefresh | Refresh the buffer for the current Workarea, discarding any changes that were made. |
| ClearFilter |
Clear a logical filter condition.
|
| ClearLocate |
Clear a locate condition by deleting the locate code block.
|
| ClearRelation | Clear any active relations. |
| ClearScope | Clear the active locate condition. |
| CloseAll |
Close all files in all work areas.
|
| CloseArea |
Close all files in a work area.
|
| Commit |
Flush pending updates in one work area.
|
| CommitAll |
Flush pending updates in all work areas.
|
| Continue |
Resume a pending locate condition.
|
| Create(String, RddFieldInfo, String, Logic, String, String, Logic, Logic) |
Create new file through the specified RDDs
|
| Create(String, RddFieldInfo, Type, Logic, String, String, Logic, Logic) |
Create new file through the specified RDDs
|
| Create(String, RddFieldInfo, _RddList, Logic, String, String, Logic, Logic) |
Create new file through the specified RDDs
|
| Dbf | Return the name of the alias. |
| Delete |
Mark the current record for deletion.
|
| Deleted |
Return the deleted status of the current record.
|
| Eof |
Determine when end-of-file is encountered.
|
| Eval |
Evaluate a code block for each record that matches a specified scope and/or condition.
|
| FCount | Return the number of fields in the current Workarea |
| FieldGet |
Retrieve the value of a specified database field.
|
| FieldGetBytes |
Retrieve the value of a specified database field as an array of bytes
|
| FieldInfo(DWord, DWord, Object) | Retrieve and optionally change information about a column. |
| FieldInfo(DWord, DWord, Object) | Retrieve and optionally change information about a column. |
| FieldName |
Return the name of a field as a string.
|
| FieldPos |
Return the position of a field.
|
| FieldPut |
Set the value of a specified database field.
|
| FieldPutBytes |
Retrieve the value of a specified database field as an array of bytes
|
| FileGet | Import contents from file into Memo field |
| FilePut | Export field contents from Memo field to file |
| Filter |
Return a filter.
|
| Flock |
Lock an opened and shared database file.
|
| Found |
Determine if the previous search operation succeeded.
|
| GetScope | Gets the locate condition. |
| GetSelect |
Return the work area number.
|
| GoBottom |
Move to the last logical record.
|
| Goto |
Move to a record specified by record number.
|
| GoTop |
Move to the first logical record.
|
| Header | |
| Info(DWord, Object) |
Retrieve information about a work area.
|
| Info(DWord, Object) |
Retrieve information about a work area.
|
| JoinAppend | Write values to destination Workarea in a JOIN operation |
| LastRec |
Return the number of the last record in a database file.
|
| Locate |
Search for the first record that matches a specified condition and scope.
|
| MemoExt | Return Memo File extension |
| OrdBagExt |
Return the default index file extension for a work area as defined by the its RDD.
|
| OrdCondSet |
Set the condition and scope for an order.
|
| OrdCreate |
Create or replace an order in an index file.
|
| OrdDestroy |
Remove an order from an open index file.
|
| OrderInfo(DWord, String, Object, Object) |
Return information about index files and the orders in them.
|
| OrderInfo(DWord, String, Object, Object) |
Return information about index files and the orders in them.
|
| OrdListAdd |
Open an index file and add specified orders to the order list in a work area.
|
| OrdListClear |
Remove orders from the order list in a work area and close associated index files.
|
| OrdListRebuild |
Rebuild all orders in the order list of a work area.
|
| OrdSetFocus(String, Object) |
Set the controlling order for a work area.
|
| OrdSetFocus(String, Object, String) |
Set the controlling order for a work area.
|
| Pack |
Remove all records that have been marked for deletion from a database file.
|
| RddCount | |
| RddInfo(DWord, Object) | Return and optionally change settings controlled directly by the RDD. |
| RddInfo(DWord, Object) | Return and optionally change settings controlled directly by the RDD. |
| RddList | Returns list of RDD names that are in use at this moment |
| RddList(_RddList, DWord) | Obsolete. |
| RddName |
Return an RDD name.
|
| RddSetDefault |
Return and optionally change the default RDD for the application.
|
| Recall |
Restore the current record if it is marked for deletion.
|
| Recno |
Return the current record number.
|
| RecordGet | Get the contents of the current record as an array of bytes |
| RecordInfo(DWord, Object, Object) |
Retrieve information about a record.
|
| RecordInfo(DWord, Object, Object) |
Retrieve information about a record.
|
| RecordPut | Update the current record from an array of bytes |
| RecSize | Return the record length in the current Workarea |
| Refresh |
Discard all the changes to the current workares
|
| Relation |
Return the linking expression of a specified relation.
|
| RLock |
Lock the current record.
|
| RSelect |
Return the work area number of a relation.
|
| Seek |
Move to the record having the specified key value.
|
| Select |
Select a new work area and retrieve the current work area.
|
| SetFilter |
Set a filter condition.
|
| SetFound |
Set the found flag.
|
| SetLocate |
Specify the code block for a locate condition.
|
| SetRelation |
Relate a specified work area to the current work area.
|
| SetScope | Set the locate condition. |
| SetSelect |
Select a new work area.
|
| Skip |
Move the record pointer relative to the current record.
|
| SkipScope | Position the cursor relative to its current position within the current scope. |
| Sort | Copy records to a database file in sorted order. |
| SymSelect |
Select a new work area by specifying its alias as a string and return the number of the current work area.
|
| Trans | Copy one or more rows from one work area to another. |
| TransRec | Copy a single row from one work area to another. |
| Unlock |
Release all locks for a work area.
|
| UnlockAll | Release all locks for all work areas. |
| UseArea(Logic, String, String, String, Logic, Logic) |
Open a database file.
|
| UseArea(Logic, Type, String, String, Logic, Logic) |
Open a database file.
|
| UseArea(Logic, _RddList, String, String, Logic, Logic) |
Open a database file.
|
| Zap | Remove all records from the current Workarea. |
Events| Name | Description | |
|---|---|---|
 | Notify |
An event to which you can subscribe to be notified of operations on Workareas.
|
See Also