Workarea Methods |  |
The Workarea type exposes the following members.
Functions| Name | Description | |
|---|---|---|
 | _getMemoBlockNumber | |
| AddField | Add a column. |
| Append | Append a blank row and position the cursor to the new row. |
| AppendLock | Add a newly appended row to the list of locked rows. |
| BlobInfo | Retrieve information about a memo column. |
| ChildEnd | Report the initialization of a relation. |
| ChildStart | Report the initialization of a relation. |
| ChildSync | Post a pending relational movement, indicating that the specified child work area has been affected by a parental movement. |
| ClearFilter | Clear the active filter condition. |
| ClearRel | Clear relations. |
| ClearScope | Clear the active locate condition. |
| Close | Close a table. |
| CloseMemFile | Close the memo file |
| Compile | Compile an expression. |
| Continue | Goto the next record based on the corrent locate condition. |
| Create | Create a table. |
| CreateFields | Add columns defined in an array. |
| CreateMemFile | Create the memo file |
| DbEval | Evaluate a code block for each row. |
| Delete | Mark the row at the current cursor position for deletion. |
| Dispose | |
| Dispose(Logic) | |
| EvalBlock | Evaluate a code block. |
| EvalFilter | |
| FieldIndex | Return the ONE based field index for a field name. |
| FieldInfo | Retrieve and optionally change information about a column. |
| FieldName | Retrieve a column name based on its ONE based column number. |
| Flush | Flush the changes to the table, its indexes and memo file. |
| ForceRel | Force all pending relational seeks to be performed. |
| GetField |
Return the (1 based) RddFieldInfo object for the specified field
|
| GetRec | Retrieve the RDD's record buffer as array of bytes. |
| GetScope | Retrieve the active locate condition. |
| GetValue | Get a value for the specified column. |
| GetValueFile | Get the value for a column and write (export) it to an external file. |
| GetValueLength | Get the length of the for the specified column. |
| GoBottom | Position the cursor to the last logical row. |
| GoCold | Write the contents of a work area's memory to the data store (usually a disk). |
| GoHot | Mark a data buffer as hot, indicating that it needs to be written to the data store. |
| GoTo | Position the cursor to a specific, physical row. |
| GoToId | Position the cursor to a specific, physical identity. |
| GoTop | Position the cursor to the first logical row. |
| HeaderLock | Lock or unlock the header of a database file. |
| Info | Retrieve and optionally change information about a work area. |
| Lock | Perform a lock. |
| Open | Open a table. |
| OpenMemFile | Open the memo file |
| OrderCondition | Set the condition for the next Index Creation |
| OrderCreate | Create a new index or tag. |
| OrderDestroy | Delete an index or tag. |
| OrderInfo | Retrieve information about an index. |
| OrderListAdd | Open an index file and add to the list of open indexes for the current Workarea. |
| OrderListDelete | Close an index file and remove it from the list of open indexes for the current Workarea. |
| OrderListFocus | Set focus to another index in the list open indexes for the current Workarea. |
| OrderListRebuild | Rebuild all indexes for the current Workarea. |
| Pack | Physically remove rows marked for deletion. |
| PutRec | Replace the row at the current cursor position with the contents of a byte array. |
| PutValue | Write a value for a specified column |
| PutValueFile | Read (Import) a value from an external file and write it to the specified column. |
| Recall | Remove the deletion marker from the row at the current cursor position. |
| RecInfo | Retrieve and optionally change information about a row. |
| 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. |
| RelArea | Retrieve the logical number of a related work area. |
| RelEval | Evaluate a code block against the relation in a work area. |
| RelText | Retrieve the key expression of a relation. |
| Seek | Perform a seek operation on the current selected index for the current Workarea. |
| SetFieldExtent | Set the Number of Fields the AddField Method will add. |
| SetFilter | Set the filter condition. |
| SetRel | Set a relation. |
| SetScope | Set the locate condition. |
| Skip | Position the cursor relative to its current position. |
| SkipFilter | Position the cursor, respecting scope and filter conditions. |
| SkipRaw | Position the cursor regardless of scope and filter conditions. |
| SkipScope | Position the cursor relative to its current position within the current scope. |
| Sort | Physically reorder a table. |
| SyncChildren | Force relational movement in child work areas to synchronize them with the parent 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 locks. |
| Zap | Physically remove all rows from a table. |
See Also