Sqlitebrowser: Update Null value to empty string without query

Created on 21 Sep 2020  路  3Comments  路  Source: sqlitebrowser/sqlitebrowser

Details for the issue

What did you do?

Trying to update null value to empty string ("") without query

What did you expect to see?

empty string ("")

What did you see instead?

Not executed, i need to run query for update. As I know, this was works in v3.11.2.

Useful extra information

DB4S v3.12.0 [built for x86_64-little_endian-llp64] on Windows 10 (10.0) (winnt/10.0.18363) [x86_64]
using SQLite Version 3.32.2
and Qt 5.12.8

picture emrecpp

Most helpful comment

If you go to the 'Browse Data' tab and select the cells you want to clear, then press [Backspace], the cells will be empty.

https://streamable.com/yhwl1d

You can also right-click and select 'Set to NULL' if you want to return them to NULL values.

picture chrisjlocke on 21 Sep 2020
👍2

All 3 comments

If you go to the 'Browse Data' tab and select the cells you want to clear, then press [Backspace], the cells will be empty.

https://streamable.com/yhwl1d

You can also right-click and select 'Set to NULL' if you want to return them to NULL values.

chrisjlocke picture chrisjlocke on 21 Sep 2020
👍2

If you go to the 'Browse Data' tab and select the cells you want to clear, then press [Backspace], the cells will be empty.

https://streamable.com/yhwl1d

You can also right-click and select 'Set to NULL' if you want to return them to NULL values.

Ahaha :) Thank you

emrecpp picture emrecpp on 21 Sep 2020

Awesome. Good stuff @chrisjlocke. :smile:

justinclift picture justinclift on 21 Sep 2020
👍1
Was this page helpful?
0 / 5 - 0 ratings

Related issues

aneroid picture aneroid  路  4Comments
mgrojo picture mgrojo  路  4Comments
to302 picture to302  路  3Comments
botist picture botist  路  3Comments
henrykironde picture henrykironde  路  4Comments