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

View Text Field in Grid

User, date Message
Written by John Bell
10 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
10 months ago
5045 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
10 months ago
601 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.