Methods for Manipulating Data
Method Name
Usage
ActionAllRows()
Performs a specified action on all retrieved records of the current table.
ActionSelectedRows()
In a table with spreadsheet look, performs a specified action on all selected records.
ConvertAlternativeFormat()
Enables a field to accept a variety of input, while maintaining a consistent presentation.
DataCommit()
Saves the data in the database.
DataRdbmsStatement()
Executes stored procedures or data definition SQL statements.
DataRollback()
Rolls back all changes since the last commit.
DataToClipboard()
Copies all selected records to the clipboard.
FieldClear()
Clears the current field.
FieldDuplicate()
Copies the value of the field in the previous record into the current record.
FieldPaste()
Copies the contents of the selection buffer into the current field.
FieldSelect()
Copies the current field into the selection buffer.
LookupAccept()
Copies the data in the current record in a Lookup window into the Info window in which the Lookup was opened.
RecordClear()
Removes unchanged and posted records from a query set.
RecordClearTable()
In query mode, clears the table.
RecordClearWindows()
Clears data in all application windows.
RecordCreate()
Creates a new empty record in the window.
RecordDelete()
Deletes the current record.
RecordDuplicate()
Copies the previous record into the current (new) record.
RecordRefresh()
Displays the current record as it was at the last commit or save.
RecordSelect()
Selects the current (or specified) record.
RecordSelectAll()
Selects all records retrieved by the last query.
RecordStore()
Stores the selected records internally (they are not saved, but are known to other objects in the session).
RecordUndo()
Returns the record to its previous state, or deletes new records.
RecordWrite()
Writes the contents of the current record(s) to a specified file.