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

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

mraonghus posted 2 years ago in General
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?
ansgar posted 2 years ago
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?
mraonghus posted 2 years ago
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.
mraonghus posted 2 years ago
Oh wow, that was quick, thank you.
ansgar posted 2 years ago
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.