To work with current row (record), use Row menu.
Depending on active page of the main window, the current row (record) can be:
- selected record of an open database table or SQL query result set
- selected row of table fields list
- selected row of table indexes list
- selected row of table constraints list
- selected row of table foreign keys list
- selected row of table partitions list
- selected row of SQL History table
- current line of SQL editor.
Each of these row types has its own set of available capabilities. For example, printing and copying the row are available for all types.
Printing the current record of the current data set is performed in order of columns. Data of each column (field) is printed on new line in the following format: Column title: Field data.
For database records, there is a possibility to quickly duplicate the current record. The duplicated record will be inserted into the table automatically, but without saving/posting it to the database: this lets the user an ability to change the needed data (key fields etc.) before saving.
Working with Bookmarks
There is an ability to put bookmarks on the database records or lines of the SQL editor.
You can put only one bookmark on current database record (using above mentioned menu or combination CTRL+SHIFT+0) and up to ten bookmarks on SQL editor lines (using CTRL+SHIFT+n, where n is a bookmark number).
To move to previously defined bookmark, press CTRL+n, where n is the bookmark number.
There is an ability to copy database record from the current position to position before bookmark (only for non-indexed Paradox tables).
See also