Keybaord Shortcuts for editing in the grid (Excel: F2)

Toad for Oracle & DevOps Toolkit
1

Hi there

I try to edit data in the TOAD Grid with the keyboard, but cannot find the shortcut to edit existing data (as F2 is in Excel) in the Help nor with Google…

Any help is appreciated.

Jan

2

When you say “editing in the grid” do you mean the DATA grid when
you look at a table via the Schema browser or do you mean the grid after a
SELECT query is processed.
image001.jpeg

3

Or if the complex view has the appropriate “instead of” trigger to
make it work J

4

The trigger trick will allow you to make update statements against a complex
view, but it will allow editing with the grid. The grid requires a ROWID column
for editing.

5

D’oh….I meant:

The trigger trick will allow you to make update statements against a complex
view, but it will NOT allow editing with the grid. The grid requires a ROWID
column for editing.

6

Sorry for the imprecision.

I mean the grid in the schema browser, if I open a table for instance.

I can move the cursor with the keyboard arrows, no problem. But when I try to edit the content of a cell I need to click it first with the mouse, then I can edit the text. As I prefer to work with the keyboard only I wonder if there is a shortcut to make the cell “editable”. If I press backspace the whole content of the cell is gone, not what I wanted.

I’m looking for exact same functionality as has the “F2” in Excel, which makes the cell editable without deleting the contents.

Thank you

TOAD 10.1.1.8

Grid Settings: (Data Grids>Visual>Behaviour)
Tabs: on, Immediate edit: on, Tab through: off, Confirm… : off, Row select: off