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

Insert row button greyed out, unless SELECT query ran and focus set to record pane

User, date Message
Written by mraonghus
1 year ago
Category: General
3 posts since Wed, 06 Feb 13
Hi,

This is my first time using HeidiSQL but for some reason I can't seem to add records to any tables without running an INERT query.

The icon with the green plus ("Insert row into table (Ins)") is greyed out. However, if I run an insert query, the pane with the results appears and I click on that pane, the insert row button becomes available.

I'm using MySQL 5.1.43 on Windows 2008 R2. The database is local but I'm using HeidiSQL through a Remote Desktop session.

Any ideas?
Written by ansgar
1 year ago
4940 posts since Fri, 07 Apr 06
The green Insert button gets active as soon as you enter the data grid. So, as soon as you click on the "Data" tab, you should see the green button active.

And most important: Which HeidiSQL revision is it?
Written by mraonghus
1 year ago
3 posts since Wed, 06 Feb 13
Ok, I'm an idiot.

I didn't notice the 'Data' tab.
Once I enter that tab I can add records.

Hope this helps someone else.
Written by mraonghus
1 year ago
3 posts since Wed, 06 Feb 13
Oh wow, that was quick, thank you.
Written by ansgar
1 year ago
4940 posts since Fri, 07 Apr 06
Well you can also edit data in a query tab, but only if the query is simple. Means: only one table is involved, and you have selected primary or unique key columns.
 

Please login to leave a reply, or register at first.