editcellwith
TEXT
The editcellwith statement opens the edit window for the currently active field (or cell), using the supplied alternate text.
Parameters
This statement has one parameter:
text – initial text to appear in the edit window.
Description
This statement opens the edit window for the current field allowing you to make changes to the field manually. After this statement opens the edit window the procedure will suspend operations temporarily until you manually close the edit window, then the procedure will continue after the editcellwith statement.
This statement is nearly identical to the editcell statement. However, instead of initializing the editor window with the text in the current database cell, this statement initializes the editor with the specified text. This example edits the Country field, with a default value of United States. If United States is what you want then just press the Return key, otherwise edit the text to whatever you want.
field Country
editcellwith "United States"
Here is a very similar example using the editcell statement:
field Country
Country = "United States"
editcell
The difference is that this second example modifies the database immediately, before editing even begins. The previous example, using the editcellwith statement, does not modify the database before editing begins. If you want to restore the previous value of the Country cell, you can just press the Escape key. Since the database hasn’t been modified yet, pressing the Escape key leaves the database as it was.
See Also
- addrecord -- adds a new record at the end of the current database.
- change -- replaces text with new text in the current field (selected records only).
- changeword -- replaces one word with another in the current field (selected records only).
- changewordexact -- replaces one word with another in the current field (selected records only).
- clearcell -- deletes the contents of the current field.
- clearrecord -- deletes the currently selected record.
- copycell -- copies the contents of the current field onto the clipboard,
replacing anything previously on the clipboard.
- copyrecord -- copies the contents of the current record onto the clipboard.
- cutcell -- delete the contents of the current cell and places the deleted data on the clipboard.
- cutline -- copies the current record to the clipboard and deletes it.
- cutrecord -- copies the current record to the clipboard and deletes it.
- Data Input Validation -- validation of data entry (checking for duplicates, etc.)
- deleteabove -- copies the current record to the clipboard and deletes it, then moves to the record above.
- deleteall -- removes all records, leaving a single blank record.
- deleterecord -- deletes the currently selected record.
- duplicaterecord -- duplicates the current record.
- editcell -- opens the edit window for the currently active field (or cell), highlighting the data, and allows you to edit that field.
- editcellstop -- opens the edit window for the currently active field (or cell), highlighting the data, and allows you to edit that field.
- emptyfill -- fills every empty visible cell in the active field with the specified value.
- fill -- fills every visible cell in the active field with the specified value.
- fillall -- modifies the operation of the following *fill* statement so that all records are modified, not just visible records.
- formulafill -- fills every visible cell in the active field with the result of the specified formula.
- formulafillallfields -- fills every visible cell in all fields with the result of the specified formula.
- insertbelow -- inserts a new record below the current record.
- insertbelowcarriagereturn -- inserts a new record below the current record and moves to the first column.
- insertrecord -- inserts a new record above the current record.
- moverecorddown -- moves the current record down one line.
- moverecordup -- moves the current record up one line.
- outlinelevel -- expands or collapses the entire database to show a specific level of data or summary level.
- pastecell -- pastes the contents of the clipboard into the current cell.
- pasteline -- inserts a new record containing the contents of the clipboard.
- pasterecord -- inserts a new record containing the contents of the clipboard.
- post -- assigns a value to a field in another database.
- propagate -- fills all the empty cells in the current field. Each empty cell is filled with the value of the first non-empty cell above it.
- propagateup -- fills all the empty cells in the current field. Each empty cell is filled with the value of the first non-empty cell below it.
- removeselected -- deletes all selected records from the database.
- removeunselected -- deletes all unselected records from the database.
- resetallrecordidts -- resets the internal record id and time stamps for every record in the current database.
- runfieldcalculations -- performs any automatic calculations associated with the current field.
- runfieldsideeffects -- performs any side effects associated with the current field (calculations, procedures, etc.).
- runningdifference -- calculates the running difference for the current field.
- runningtotal -- calculates the running total for the current field.
- sequence -- fills every visible cell in the current field with a numeric sequence.
- speedcopy -- copies multiple adjacent fields from a record in one database to a record in another.
- summarylevel -- changes the summary level of the current line.
- unpropagate -- removes repeating data from the currently selected field. If several records in a row contain the same data, this statement erases all but the first (top) value.
- unpropagateup -- removes repeating data from the currently selected field. If several records in a row contain the same data, this statement erases all but the last (bottom) value.
History
| 10.2 | New | New in this version. |