Ansgar Becker

Results 304 comments of Ansgar Becker

Yes, the table editor has still quite lots of places with MySQL/MariaDB-only commands. I need to separate these out into snippets for each rdbms.

SynEdit in HeidiSQL is mostly the latest stable version. If you compare the sources they should be equal in most places. Pull requests are only accepted for bug fixes, not...

The current reformat logic was a quick shot, some years ago, but at least gave me line breaks where I wanted them. This, and also the fact that it's my...

Yea, interesting idea. I just found a free SQL formatter written in Delphi: https://github.com/SqlToys/SqlFormatter I could contact the author if he's permitting HeidiSQL to use that. And probably also ask...

Or I'll give it a try and enhance my existing formatter first. The other options have their own disadvantages. I should at least check how much effort it will be...

jdorn's parser creates following output, quite impressive: ```sql SELECT el.ID, el.NAME, el.IBLOCK_SECTION_ID, price.PRICE FROM b_iblock_element el JOIN b_iblock_element_property SHOW_IN_CAT ON ( SHOW_IN_CAT.IBLOCK_ELEMENT_ID = el.ID AND SHOW_IN_CAT.IBLOCK_PROPERTY_ID = 716 AND SHOW_IN_CAT.VALUE...

Yes, and that library seems to be unmaintained since 2015. Not the best option probably.

I must admit I did not care too much about binary field values, but using the latest release plus updates to the nightly builds makes deleting rows work quite normal....

v12.0 has some improvements for binary columns, especially when used in foreign key constraints, and in the quick filter actions. The popup editor for binary/hex content is indeed still broken,...