View Text Field in Grid

John Bell's profile image John Bell posted 10 years ago in General Permalink
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's profile image ansgar posted 10 years ago Permalink
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's profile image kalvaro posted 10 years ago Permalink
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.