Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

adding column to table visually fails with 102 on save

jwitschger@gmail.com's profile image jwitschger@gmail.com posted 1 month ago in General Permalink

Downloaded latest update Existing Table in table view mode (not data) Add column, change name, set length and then SAVE 102 error every single time, sometimes on lines that are not the one I just added The query that is shown is clearly wrong as it lists the column name twice shown below.

Alter Table Alter Column 'xxx' 'xxx' Nvarchar(50)....

I copied the query to SSMS and deleted the repeated column and it worked fine ... but I am trying to move away from SSMS

I got used to this program really fast and for what I do which is build databases and modify data, I like this much more than DBeaver, but the inability to add a column successfully is a pain. That, and I would like to see the ability to move a column up or down turned on. The menu has this, but is inactive. And the drag works, but does not stick.

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




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.