Claus Pedersen
Member³
In an SQL window grid, I edit data from a table with a check constraint saying that the column can only contain certain string values (e.g. Y and N).
The grid data is shown with a small triangle icon to indicate the list. If I open the list with the mouse, it shown Y and N and I can select one. This is by design.
But if I press Alt-Down to activate the list, a smiley face character (ASCII 2?) replaces the data in the grid. If you have not noticed it and try to save the data, the update will not succeed because of a check constraint violation. The problem is that the original data is deleted and you have to re-query to start over. If you press Alt-Up, another icon is shown (ASCII 8?).
It only seems to happen when using Alt-Down in the lists caused by check constraints or foreign keys.
Please fix this.
The grid data is shown with a small triangle icon to indicate the list. If I open the list with the mouse, it shown Y and N and I can select one. This is by design.
But if I press Alt-Down to activate the list, a smiley face character (ASCII 2?) replaces the data in the grid. If you have not noticed it and try to save the data, the update will not succeed because of a check constraint violation. The problem is that the original data is deleted and you have to re-query to start over. If you press Alt-Up, another icon is shown (ASCII 8?).
It only seems to happen when using Alt-Down in the lists caused by check constraints or foreign keys.
Please fix this.
