Database Navigation & Editing

This page is currently incomplete, but you can find information about this topic at the links below:

- addlines -- The addlines statement adds a specified number of records to the end of a database.
- addrecord -- The addrecord statement adds a new record at the end of the current database.
- clearcell -- The clearcell statement deletes the contents of the current field.
- clearrecord -- The clearrecord statement deletes the currently selected record.
- copycell -- The copycell statement copies the contents of the current field onto the clipboard, replacing anything previously on the clipboard.
- copyrecord -- The copyrecord statement copies the contents of the current record onto the clipboard.
- cutcell -- The cutcell statement delete the contents of the current cell and places the deleted data on the clipboard.
- cutline -- The cutline statement copies the current record to the clipboard and deletes it.
- cutrecord -- The cutrecord statement copies the current record to the clipboard and deletes it.
- deleteabove -- The deleteabove statement copies the current record to the clipboard and deletes it, then moves to the record above.
- deleterecord -- The deleterecord statement deletes the currently selected record.
- downrecord -- The downrecord statement moves the cursor down one visible record.
- duplicaterecord -- The duplicaterecord statement duplicates the current record.
- editcell -- The editcell statement opens the edit window for the currently active field (or cell), highlighting the data, and allows you to edit that field.
- editcellstop -- The editcellstop statement opens the edit window for the currently active field (or cell), highlighting the data, and allows you to edit that field.
- editcellwith -- The editcellwith statement opens the edit window for the currently active field (or cell), using the supplied alternate text.
- field -- The field statement tells Panorama to move to the specified field for the current record.
- firstcolumn -- The firstcolumn statement moves to the first column in the data sheet (leftmost column).
- firstrecord -- The firstrecord statement makes the first visible (selected) record in the database the active record.
- info("bof") -- The info("bof") function returns true if the active record is currently on the first visible (selected) record.
- info("eof") -- The info("eof") function returns true if the active record is currently the last visible (selected) record.
- info("fieldname") -- The info("fieldname") function returns the name of the current field.
- info("fieldnumber") -- The info("fieldnumber") function returns the number of the current field (starting from 1).
- info("serverrecordid") -- The info("serverrecordid") function returns the unique ID number for the current record.
- info("serverrecordts") -- The info("serverrecordts") function returns the internal time stamp associated with the current record.
- info("stopped") -- The info("stopped") function returns true or false depending on the whether the last uprecord, downrecord, left or right statement succeeded or failed.
- insertbelow -- The insertbelow statement inserts a new record below the current record.
- insertbelowcarriagereturn -- The insertbelowcarriagereturn statement inserts a new record below the current record and moves to the first column.
- insertrecord -- The insertrecord statement inserts a new record above the current record.
- lastcolumn -- The lastcolumn statement move to the last column in the data sheet (rightmost column).
- lastrecord -- The lastrecord statement makes the last visible (selected) record in the database the active record.
- left -- The left statement makes the previous field active in the active window.
- pastecell -- The pastecell statement pastes the contents of the clipboard into the current cell.
- pasteline -- The pasteline statement inserts a new record containing the contents of the clipboard.
- pasterecord -- The pasterecord statement inserts a new record containing the contents of the clipboard.
- right -- The right statement moves the cursor to the next field in the active window.
- runfieldcalculations -- The runfieldcalculations statement performs any automatic calculations associated with the current field.
- runfieldsideeffects -- The runfieldsideeffects statement performs any side effects associated with the current field (calculations, procedures, etc.).
- unlockrecord -- The unlockrecord statement unlocks the currently active record.

History

Version | Status | Notes
10.0 | Updated | Carried over from Panorama 6.0, with some updates.