search

pawelsalawa / sqlitestudio

A free, open source, multi-platform SQLite database manager.
https://sqlitestudio.pl
Other
4.59k stars 569 forks source link

Inline editing/view causes certain BLOB become to empty in session #4271

Open yfdyh000 opened 2 years ago

yfdyh000 commented 2 years ago

Details

See below. If you need, I can send the file by email.

Steps to reproduce

  1. Open the AppData\Local\SalSoft\SQLiteStudio\settings3 file (or it's copy).
  2. Go to settings table - Data view - General.Session. It shows a blank value and a blue ">>" for loading remaining data.
  3. If I double-click this cell, it appears as an empty string. If I first click the ">>", there is no difference.
  4. After operation, the cell is a blank text value, and there is no changed state in the software. At this point, even opening the editing value in editor, it also appears as an empty string for text/image/hex view.
  5. The only effective method for viewing and editing it, is editing value in editor directly, and goes to the HEX view.

Operating system

Win10

SQLiteStudio version

3.3.3

yfdyh000 commented 2 years ago

BTW, I didn't see any effective method for copying or export the value of the BLOB. The https://sqlitebrowser.org/ provides a more complete actions for blob (HEX) object.