Previous Topic

Next Topic

Form Designer Table Methods

Navigator > Setup > Form Designer > Code tab

Components each have different methods available to them. Methods available are listed under Objects > [Component Type] > [Component Name] > Methods.

See also Form Designer Component Methods for methods available to all component types.

The following methods are available to Table and Memory Table Components:

Component

Method

Description

Memory Table

AddField

Add a field to the graph or table definition.

Memory Table

 

AddIndex

Add a new index to the Memory Table.

Memory Table, Table

Append

Append a record to the memory table.

Memory Table

ApplyOrder

Order items in the memory table in order of a supplied array.

Memory Table

Cancel

Cancel pending changes that haven't been saved.

Table, Memory Table

 

CancelRange

Cancels the range that has been set for the table.

Memory Table

ClearFields

Clears all the field definitions.

Memory Table, Table

Clone

Copy field and index definitions from another table and links the tables.

Memory Table

CopyTable

Copy field and index definitions from another table.

Memory Table, Table

Delete

Delete the current row from the table or memory table.

Memory Table, Table

Edit

Opens the table or memory table for editing.

Memory Table

Empty

Empties all data from the memory table.

Memory Table, Table

Find

Finds the closest match in a table.

Memory Table, Table

FindExact

Finds an exact match in a table.

Memory Table, Table

First

Go to the first record in a table.

Memory Table, Table

Insert

Insert a record at the current position in a table.

Memory Table, Table

Last

Go to the last record in a table.

Memory Table

LoadFromCSV

Populate a memory table from a CSV file.

Memory Table

LoadFromExcel

Populate a memory table from an Excel file.

Memory Table

LoadFromFile

Populate a memory table from a delimited file.

Memory Table, Table

Next

Go to the next record in a table.

Memory Table, Table

Prev

Go to the previous record in a table.

Memory Table, Table

Refresh

Refresh data in a table.

Memory Table, Table

Save

Save data in a table.

Memory Table

SaveToCSV

Export data from a memory table to a CSV file.

Memory Table

SaveToExcel

Export data from a memory table to an Excel file.

Memory Table

SaveToFile

Export data from a memory table to a delimited file.

Memory Table, Table

SetRange

Set a range, and move to the first record in the range.

Table, Memory Table

SetRangeEnd

Set the value(s) for the end of the range to be included.

Table, Memory Table

SetRangeStart

Set the value(s) for the start of the range to be included.

Memory Table, Table

ShowFieldErrorHint

Display an error hint on a field in a table.

Memory Table

Sort

Sort a table by fields listed.

Table

StampModified

For custom tables, updates the tracking fields.

Memory Table

 

StartFormUpdates

When a memory table is bound to a grid on a form, this starts the grid being automatically updated.

Memory Table

StopFormUpdates

When a memory table is bound to a grid on a form, this stops the grid being automatically updated.

Memory Table

SwapDown

Move the current record down one position.

Memory Table

SwapUp

Move the current record up one position.

In This Section

AddField - Memory Table Builder Method

AddIndex - Memory Table Method

Append - Memory Table Method

ApplyOrder - Memory Table Method

Cancel - Memory Table Method

CancelRange - Memory Table Method

ClearFields - Memory Table Builder Method

Clone - Memory Table Method

CopyTable - Memory Table Method

Delete - Memory Table Method

Edit - Memory Table Method

Empty - Memory Table Method

Find - Memory Table Method

FindExact - Memory Table Method

First - Memory Table Method

Insert - Memory Table Method

Last - Memory Table Method

LoadFromCSV - Memory Table Method

LoadFromExcel - Memory Table Method

LoadFromFile - Memory Table Method

Next - Memory Table Method

Prev - Memory Table Method

Refresh - Memory Table Method

Save - Memory Table Method

SaveToCSV - Memory Table Method

SaveToExcel - Memory Table Method

SaveToFile - Memory Table Method

SetRange - Memory Table Method

SetRangeEnd - Memory Table Method

SetRangeStart - Memory Table Method

ShowFieldErrorHint - Method

Sort - Memory Table Method

StampModified

StartFormUpdates - Memory Table Method

StopFormUpdates - Memory Table Method

SwapDown - Memory Table Method

SwapUp - Memory Table Method

See Also

Form Designer Code tab

Book Contents

Book Index