This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 237652 - Simplyfy access to "Set cell to null" in db dataview
Summary: Simplyfy access to "Set cell to null" in db dataview
Status: VERIFIED FIXED
Alias: None
Product: db
Classification: Unclassified
Component: Show Data (show other bugs)
Version: 7.4
Hardware: PC Windows 8 x64
: P3 normal with 1 vote (vote)
Assignee: Libor Fischmeistr
URL:
Keywords:
Depends on: 243802
Blocks:
  Show dependency tree
 
Reported: 2013-10-25 10:10 UTC by akobberup
Modified: 2014-07-19 15:09 UTC (History)
0 users

See Also:
Issue Type: ENHANCEMENT
Exception Reporter:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description akobberup 2013-10-25 10:10:02 UTC 
It would be nice to have an option in the data table from the resultset of a select query to be able to set date fields to null, without having to type in the sql.

The date fields can be edited via the inline date selection component, but there is - as far as i know - no where to set the date to null in the gui; you have to write the update in the sql editor..
Comment 1 matthias42 2013-10-25 17:17:36 UTC 
You can set it to null: Select cell, press STRG+0, the field is set to null, if it is nullable. Feel free to reopen if this does not work for you.
Comment 2 akobberup 2013-10-28 07:12:37 UTC 
Thanks a lot - it works perfectly.


How come this is not an option in the contextual menu when right clicking the cell?

Generally it seems to be a pretty well hidden feature - the shortcut do not show up in the key map as well (Ctrl/Strg + 0 usually set focus in the editor).
Comment 3 matthias42 2013-10-29 19:10:02 UTC 
The question is IMHO justified - but i have to say, that I'm not a netbeans developer. But I closed this, so I'll reopen with a different title.

The context menu could be a valid place, but when adding it there it should be checked if it gets to full.
Comment 4 Libor Fischmeistr 2014-07-08 11:15:52 UTC 
Fixed in changeset http://hg.netbeans.org/core-main/rev/f47901d8d934 related to issue 243802
Comment 5 matthias42 2014-07-19 15:09:36 UTC 
Thank you!