Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

View Text Field in Grid

John Bell's profile image John Bell posted 8 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 8 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 8 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.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.