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

[expired user #6794]'s profile image [expired user #6794] posted 11 years ago in General Permalink
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's profile image ansgar posted 11 years ago Permalink
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?
[expired user #6794]'s profile image [expired user #6794] posted 11 years ago Permalink
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.
[expired user #6794]'s profile image [expired user #6794] posted 11 years ago Permalink
Oh wow, that was quick, thank you.
ansgar's profile image ansgar posted 11 years ago Permalink
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.