distal-attribute
distal-attribute
distal-attribute
distal-attribute

View Text Field in Grid

John Bell posted 1 year ago in General
I run a query which creates a text field. if i double click on the field in the results grid, i get an error: Grid editing error. Selected columns don't containa sufficient set of key columns to allow editing. Please select primary or unique key columns, or just all columns. It seems to me, i should be able to view the text field somehow. Am i missing something here? Thanks.
ansgar posted 1 year ago
That message should be clear enough: "Please select primary or unique key columns". Does the table have a primary or unique key? If not, create one. Editing in a grid requires such a key, for UPDATEs and DELETEs. Otherwise HeidiSQL is forced to use all columns, and you have probably deselected one or more columns.
kalvaro posted 1 year ago
Leave the mouse pointer over the cell and the complete text will show up within a tooltip. If you double click you're telling HeidiSQL to edit.

Please login to leave a reply, or register at first.