SQLPro
SQLPro copied to clipboard
The edit selected row screen is not accepting new values
Describe the bug The edit selected row screen doesn't accept changes to a record when a new value is typed in the edit box (although making the value NULL by clicking that button works). I can only make changes to a record directly in the data grid. However, when I do that, the generated UPDATE command puts single quotes around each value even if the column is an integer.
To Reproduce In the attached video, the FlagNumber column is an integer. I show the edit selected row screen and try to change the value. I exit the edit selected row screen and change the value to 6 directly in the grid. The UPDATE statement incorrectly puts the 6 in single quotes.
Expected behavior The value entered in the bottom of the edit selected row screen should change the value in the top part of the screen. When changes are made directly in the data grid, the UPDATE command should add quotes only if the column is a text, char, etc., not an integer, real, etc..
Screenshots
https://github.com/user-attachments/assets/1434d28f-5e84-4efd-a075-8923ef06500c
Environment details (please complete the following information):
- Device: iMac
- OS: macOS Ventura 13.7.4
- SQLPro app Version: SQLPro for SQLite Version 2025.06 (Build 4386)