DBFVFPSQL Methods |  |
The DBFVFPSQL type exposes the following members.
Functions| 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.) |
See Also