TablePlus-Windows icon indicating copy to clipboard operation
TablePlus-Windows copied to clipboard

Menu - Edit - Commit - not picking up changes in the SQL and therefore not changing the field in the record.

Open SirDeacs opened this issue 1 year ago • 2 comments

Please answer the questions below, it helps us to track the issue.

  1. Which driver are you using and version of it (Ex: PostgreSQL 10.0): MS SQL Server 2019 image

  2. Which TablePlus build number are you using (the number on the welcome screen, Ex: build 81): Version 5.8.0 (256)

  3. The steps to reproduce this issue: Connect to SQL database Select table highlight a field click to edit. change value click on next row or next field - changed field goes amber Menu - Edit - Commit - change fails repeat then go Menu - Edit - Preview - you can see the sql has not picked up the changes

Everything used to be fine.

Have tried different servers, different tables - always the same problem

Noted: If the bug is related to data, please attach an example SQL data.

SirDeacs avatar Jan 24 '24 20:01 SirDeacs

Table changes work fine using MS SQL Manager with same credentials.

SirDeacs avatar Jan 24 '24 20:01 SirDeacs

Hi @SirDeacs, I have tested on my database but everything worked fine. As your description that your preview window was empty although the changed field went amber. Could you please give me a piece of your table data and structure? It might help us to find out the problem. Thank you for your feedback.

sonswift avatar Jan 25 '24 00:01 sonswift