Workarea Class

Retrieve the alias name.

Retrieve the Workarea number.

Is the table at the logical beginning-of-file.

Is at bottom ?

Is the current row deleted?

Driver (RDD) name of the object.

Is the table at the logical end-of-file.

Is the Workarea opened Exclusively

The # of fields in the current Workarea.

File name of the main file

Current Filter

The filter condition as a string.

The outcome of the last search operation.

Current memo implementation.

Current Order condition

Is the file opened ReadOnly ?

The number of rows.

The row identifier at the current cursor position.

The physical row identifier at the current cursor position.

Current Record

Is the current Workarea opened Shared?

Is at top?

Add a column.

Append a blank row and position the cursor to the new row.

Add a newly appended row to the list of locked rows.

Retrieve information about a memo column.

Report the initialization of a relation.

Report the initialization of a relation.

Post a pending relational movement, indicating that the specified child work area has been affected by a parental movement.

Clear the active filter condition.

Clear relations.

Clear the active locate condition.

Close a table.

Close the memo file

Compile an expression.

Goto the next record based on the corrent locate condition.

Create a table.

Add columns defined in an array.

Create the memo file

Evaluate a code block for each row.

Mark the row at the current cursor position for deletion.

Releases all resources used by the Workarea

Releases the unmanaged resources used by the Workarea and optionally releases the managed resources

Evaluate a code block.

Return the ONE based field index for a field name.

Retrieve and optionally change information about a column.

Retrieve a column name based on its ONE based column number.

Flush the changes to the table, its indexes and memo file.

Force all pending relational seeks to be performed.

Retrieve the RDD's record buffer as array of bytes.

Retrieve the active locate condition.

Get a value for the specified column.

Get the value for a column and write (export) it to an external file.

Get the length of the for the specified column.

Position the cursor to the last logical row.

Write the contents of a work area's memory to the data store (usually a disk).

Mark a data buffer as hot, indicating that it needs to be written to the data store.

Position the cursor to a specific, physical row.

Position the cursor to a specific, physical identity.

Position the cursor to the first logical row.

Lock or unlock the header of a database file.

Retrieve and optionally change information about a work area.

Perform a lock.

Open a table.

Open the memo file

Set the condition for the next Index Creation

Create a new index or tag.

Delete an index or tag.

Retrieve information about an index.

Open an index file and add to the list of open indexes for the current Workarea.

Close an index file and remove it from the list of open indexes for the current Workarea.

Set focus to another index in the list open indexes for the current Workarea.

Rebuild all indexes for the current Workarea.

Physically remove rows marked for deletion.

Replace the row at the current cursor position with the contents of a byte array.

Write a value for a specified column

Read (Import) a value from an external file and write it to the specified column.

Remove the deletion marker from the row at the current cursor position.

Retrieve and optionally change information about a row.

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.

Retrieve the logical number of a related work area.

Evaluate a code block against the relation in a work area.

Retrieve the key expression of a relation.

Perform a seek operation on the current selected index for the current Workarea.

Set the Number of Fields the AddField Method will add.

Set the filter condition.

Set a relation.

Set the locate condition.

Position the cursor relative to its current position.

Position the cursor, respecting scope and filter conditions.

Position the cursor regardless of scope and filter conditions.

Position the cursor relative to its current position within the current scope.

Physically reorder a table.

Force relational movement in child work areas to synchronize them with the parent work area.

Copy one or more rows from one work area to another.

Copy a single row from one work area to another.

Release locks.

Physically remove all rows from a table.

List of Fields