How do you set a value to null in the data browser?

[JC3]

How do you set a value to null in the data browser, aside from doing it directly with a sql query?

I couldn't find anything in the wiki or browsing around through the application.

Sorry, but I was unable to find a way to contact you besides filing a bug report.

Thanks.

[justinclift]

A bug report is fine. 😄

I had a similar question not long ago too... and it turns out there's a bug in the current release which makes it hard.

First you'll probably want to grab the latest nightly build (has the bug fixed).

Then, to set a null value you edit the cell in question, then "clear" the field (there's a button).

The result should be a NULL field:

Let me know if that doesn't work for you? 😄

[JC3]

Thanks. The "clear" button was the first thing I tried, which didn't work. But I tried again after reading your reply and realized there's a bug that if the value is non-null but empty, "clear" doesn't change it to null (it only works if the current value is not empty). That's what got me. I'm going to file an issue report, unless that's the bug you were referring to?

Thanks again,
J

[justinclift]

Hmmm, it's similar to that, so it might be the same thing.

Would you be ok to try the latest nightly build and see if it still happens wrongly there?

[JC3]

Good news: It works properly in the current nightly build.

[justinclift]

Awesome. Thanks for trying it out to be sure. 😁