DBFVFPSQL Class |  |
DBFVFPSQL RDD. DBFCDX with support for the FoxPro field types and a List of Object values as backing collection for the data.
Inheritance HierarchyNamespace: XSharp.RDD
Assembly: XSharp.Rdd (in XSharp.Rdd.dll) Version: 2.21
SyntaxThe DBFVFPSQL type exposes the following members.
ConstructorsProperties| Name | Description | |
|---|---|---|
 | Alias | Retrieve the alias name. (Inherited from Workarea.) |
| Area | Retrieve the Workarea number. (Inherited from Workarea.) |
| BoF | Is the table at the logical beginning-of-file. (Inherited from DBF.) |
| Bottom | Is at bottom ? (Inherited from Workarea.) |
| Closed | Has the workarea been closed. (Inherited from Workarea.) |
| DataTable | |
| Deleted | Is the current row deleted? (Inherited from DBF.) |
| Driver | (Overrides Driver.) |
| EoF | Is the table at the logical end-of-file. (Inherited from DBF.) |
| Exclusive | Is the Workarea opened Exclusively (Inherited from Workarea.) |
| FieldCount | (Inherited from DBFVFP.) |
| FileName | File name of the main file (Inherited from Workarea.) |
| FilterInfo | Current Filter (Inherited from Workarea.) |
| FilterText | The filter condition as a string. (Inherited from Workarea.) |
| Found | (Inherited from DBF.) |
| HasProperties | Does the workarea have properties. (Inherited from Workarea.) |
| HasRelations | Does the workarea have relations. (Inherited from Workarea.) |
| IsHot | Is the current row (Inherited from DBF.) |
| IsNewRecord | Is the current row a new record (the result of Append()) (Inherited from DBF.) |
| Memo | Current memo implementation. (Inherited from Workarea.) |
| NullColumn | (Inherited from DBFVFP.) |
| OrderCondInfo | Current Order condition (Inherited from Workarea.) |
| Properties | (Inherited from Workarea.) |
| ReadOnly | Is the file opened ReadOnly ? (Inherited from Workarea.) |
| RecCount | The number of rows. (Inherited from DBF.) |
| RecId | The row identifier at the current cursor position. (Inherited from Workarea.) |
| RecNo | The physical row identifier at the current cursor position. (Inherited from DBF.) |
| RecordBuffer | Current Record (Inherited from Workarea.) |
| ReturnRawData | (Inherited from DBFFPT.) |
| Shared | Is the current Workarea opened Shared? (Inherited from Workarea.) |
| Top | Is at top? (Inherited from Workarea.) |
Methods| Name | Description | |
|---|---|---|
 | _CloseAllIndexes | (Inherited from DBFCDX.) |
| _getMemoBlockNumber | (Inherited from DBF.) |
| AddField |
Add a Field to the _Fields List. Fields are added in the order of method call
(Inherited from DBFVFP.) |
| Append | Append a blank row and position the cursor to the new row. (Overrides Append(Logic).) |
| AppendLock | Add a newly appended row to the list of locked rows. (Inherited from DBF.) |
| BlobInfo | Retrieve information about a memo column. (Inherited from DBF.) |
| ChildEnd | Report the initialization of a relation. (Inherited from DBF.) |
| ChildStart | Report the initialization of a relation. (Inherited from DBF.) |
| ChildSync | Post a pending relational movement, indicating that the specified child work area has been affected by a parental movement. (Inherited from DBF.) |
| ClearFilter | (Inherited from DBFCDX.) |
| ClearRel | Clear relations. (Inherited from DBF.) |
| ClearScope | Clear the active locate condition. (Inherited from DBF.) |
| Close | (Inherited from DBFVFP.) |
| CloseMemFile | Close the memo file (Inherited from DBF.) |
| Compile | Compile an expression. (Inherited from DBF.) |
| Continue | Goto the next record based on the corrent locate condition. (Inherited from DBF.) |
| Create | Create a table. (Overrides Create(DbOpenInfo).) |
| CreateFields | Add columns defined in an array. (Inherited from DBFVFP.) |
| CreateMemFile | Create the memo file (Inherited from DBF.) |
| DbEval | Evaluate a code block for each row. (Inherited from DBF.) |
| Delete | Mark the row at the current cursor position for deletion. (Inherited from DBF.) |
| Dispose | (Inherited from Workarea.) |
| Dispose(Logic) | (Inherited from Workarea.) |
| EvalBlock | Evaluate a code block. (Inherited from DBF.) |
| EvalFilter | (Inherited from DBF.) |
| FieldIndex | (Overrides FieldIndex(String).) |
| FieldInfo | (Inherited from DBFVFP.) |
| FieldName | Retrieve a column name based on its ONE based column number. (Inherited from DBF.) |
| Flush | (Inherited from DBFCDX.) |
| ForceRel | (Inherited from DBFCDX.) |
| GetField |
Return the (1 based) RddFieldInfo object for the specified field
(Inherited from Workarea.) |
| GetRec | Retrieve the RDD's record buffer as array of bytes. (Inherited from DBF.) |
| GetScope | Retrieve the active locate condition. (Inherited from DBF.) |
| GetValue | (Overrides GetValue(Long).) |
| GetValueFile | Get the value for a column and write (export) it to an external file. (Inherited from DBF.) |
| GetValueLength | Get the length of the for the specified column. (Inherited from DBF.) |
| GoBottom | (Inherited from DBFCDX.) |
| GoCold | (Inherited from DBFCDX.) |
| GoHot | (Inherited from DBFCDX.) |
| GoTo | (Inherited from DBFCDX.) |
| GoToId | Position the cursor to a specific, physical identity. (Inherited from DBF.) |
| GoTop | (Inherited from DBFCDX.) |
| HeaderLock | Lock or unlock the header of a database file. (Inherited from DBF.) |
| Info | Retrieve and optionally change information about a work area. (Overrides Info(Long, Object).) |
| Lock | Perform a lock. (Inherited from DBF.) |
| Open | (Inherited from DBFVFP.) |
| OpenMemFile | Open the memo file (Inherited from DBF.) |
| OrderCondition | (Inherited from DBFCDX.) |
| OrderCreate | (Overrides OrderCreate(DbOrderCreateInfo).) |
| OrderDestroy | (Inherited from DBFCDX.) |
| OrderInfo | (Inherited from DBFCDX.) |
| OrderListAdd | (Inherited from DBFCDX.) |
| OrderListDelete | (Inherited from DBFCDX.) |
| OrderListFocus | (Inherited from DBFCDX.) |
| OrderListRebuild | (Overrides OrderListRebuild.) |
| Pack | (Inherited from DBFCDX.) |
| PutRec | Replace the row at the current cursor position with the contents of a byte array. (Inherited from DBF.) |
| PutValue | (Overrides PutValue(Long, Object).) |
| PutValueFile | Read (Import) a value from an external file and write it to the specified column. (Inherited from DBFFPT.) |
| Recall | Remove the deletion marker from the row at the current cursor position. (Inherited from DBF.) |
| RecInfo | Retrieve and optionally change information about a row. (Inherited from DBF.) |
| Refresh | 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 DBF.) |
| RelArea | Retrieve the logical number of a related work area. (Inherited from DBF.) |
| RelEval | Evaluate a code block against the relation in a work area. (Inherited from DBF.) |
| RelText | Retrieve the key expression of a relation. (Inherited from DBF.) |
| Seek | (Inherited from DBFCDX.) |
| SetFieldExtent | Set the Number of Fields the AddField Method will add. (Overrides SetFieldExtent(Long).) |
| SetFilter | (Inherited from DBFCDX.) |
| SetRel | Set a relation. (Inherited from DBF.) |
| SetScope | Set the locate condition. (Inherited from DBF.) |
| Skip | Position the cursor relative to its current position. (Inherited from DBF.) |
| SkipFilter | Position the cursor, respecting scope and filter conditions. (Inherited from DBF.) |
| SkipRaw | (Inherited from DBFCDX.) |
| SkipScope | Position the cursor relative to its current position within the current scope. (Inherited from DBF.) |
| Sort | Physically reorder a table. (Inherited from DBF.) |
| SyncChildren | Force relational movement in child work areas to synchronize them with the parent work area. (Inherited from DBF.) |
| Trans | Copy one or more rows from one work area to another. (Inherited from DBF.) |
| TransRec | Copy a single row from one work area to another. (Inherited from DBF.) |
| UnLock | Release locks. (Inherited from DBF.) |
| Zap | (Inherited from DBFCDX.) |
Fields| Name | Description | |
|---|---|---|
 | _Fields | List of Fields (Inherited from Workarea.) |
| RLHitCount | (Inherited from DBF.) |
| RLMissCount | (Inherited from DBF.) |
See Also