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

View Text Field in Grid

User, date Message
Written by John Bell
9 months ago
Category: General
8 posts since Sun, 10 Nov 13
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.
Written by ansgar
9 months ago
4988 posts since Fri, 07 Apr 06
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.
Written by kalvaro
9 months ago
594 posts since Thu, 29 Nov 07
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.