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

View Text Field in Grid

John Bell posted 11 months 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 11 months 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 11 months 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.