formatage sql

i have heidi on my pc and sql format works well , but i have also heidi portable on a windows server and when i formate sql its appear ok on screen but disapers after save ! and its only on one line like select archcertif.noarch AS noarch,archcertif.typ AS typ from archcertif where archcertif.code = 5

format => SELECT archcertif.noarch AS noarch,archcertif.typ AS typ

FROM archcertif

WHERE archcertif.code = 5

save => select archcertif.noarch AS noarch,archcertif.typ AS typ from archcertif where archcertif.code = 5

The code in a VIEW is reformatted by the server: MySQL interpretes your code and transforms it into a canonical form. That way it can run under any sql mode setting and in this process all indendations are lost.

In HeidiSQL, you can again reformat the code again, by click on the button with the brush on it:

This will give you 3 different formatters to chose from: