How to edit data in the Results grid pane (Enterprise Manager)

To edit data in the Results pane grid

1. Navigate to the cells containing the data you want to change.
2. Type in the new data.

   While you are editing, the following rules apply:

   • When entering number, currency, time, or date information, use a format that will be recognized according to the specification in the Regional Settings dialog box in the Windows Control Panel (short form for dates).
   • To enter a NULL value into a cell, press CTRL+0.
   • You can edit a memo-type column (such as a text, memo, or long character column) if the column does not display <Long Text>. The Results pane can accept up to 900 characters of text in memo-type columns. If you are typing in a cell and exceed the amount of text that the Results pane can accept, the Query Designer will beep to indicate that you have exceeded this limit.
   • You cannot edit BLOB (BinaryLargeObject) data.
3. Save your changes by moving to another row in the grid.

Note The Query Designer does not automatically save your changes if you switch to another pane. If you edit the current query (for example, by making a change in the Grid Pane), the Results pane is dimmed. However, it is still active, and you can still edit and save the row on which you had been working.