AXSQLVFP Class

Initializes a new instance of the AXSQLVFP class

Retrieve the alias name.

Retrieve the Workarea number.

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

Is at bottom ?

Has the workarea been closed.

Is the current row deleted?

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.

Does the workarea have properties.

Does the workarea have relations.

Current memo implementation.

Current Order condition

Is the file opened ReadOnly ?

The row identifier at the current cursor position.

Current Record

Is the current Workarea opened Shared?

Is at top?

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

This method is not supported by the AdsRDD class

This method is not supported by the AdsRDD class

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.

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.

This method is not supported by the AdsRDD class

Return the (1 based) RddFieldInfo object for the specified field

This method is not supported by the AdsRDD class

Retrieve the active locate condition.

This method is not supported by the AdsRDD class

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.

This method is not supported by the AdsRDD class

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.

This method is not supported by the AdsRDD class

This method is not supported by the AdsRDD class

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 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.

This method is not supported by the AdsRDD class

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