Ads were blocked by your webbrowser.

This is not a problem, but keep in mind that developing HeidiSQL, user support and hosting takes time and money.

You may want to send a donation instead.

Snippets

Laban's profile image Laban posted 12 years ago in General
1) Where are snippets stored?
2) Some of my snippets disappeared when I changed version (tried a daily snap), just bug or are they gone?
ansgar's profile image ansgar posted 12 years ago
1) C:\Documents and settings\All Users\Application data\HeidiSQL\Snippets

2) Never saw that issue yet. Please check if some are existant in the above mentioned directory and still not displayed. If there are some, please tell us the filenames so I can fix something - thanks!
Laban's profile image Laban posted 12 years ago
There are 7 files in that directory, 3 of which does not work. All are valid queries though. Can't see why they arn't working. Just downloaded the latest snap to see if that was better, but no change.

Adresslista.sql
Kundinfo.sql
Life Lista.sql

Adresslista.sql[code:1:6de8ef49ef]USE contact_se;
SELECT
webuserid as Kundnummer,
first_name as F


Ads were blocked by your webbrowser.

This is not a problem, but keep in mind that developing HeidiSQL, user support and hosting takes time and money.

You may want to send a donation instead.
ansgar's profile image ansgar posted 12 years ago
Can't reproduce that here. It's unlikely that this issue has something to do with the file contents, as you say they are not listed in the snippet menu, correct? Maybe the files are corrupted somehow?
Laban's profile image Laban posted 12 years ago
Oh, missunderstanding then. They are listed, but when I click on one item, nothing happens - as if it knew the file was there but not being able to read its content... which reminds me to check permissions.... *checks* Nope, no difference.

Both files are written in codepage 1252 (ANSI - Latin I).

Edit:
Same problem occur when using the "Load .SQL-File" button.

Found the problem. Heidi won't read .sql files with odd characters in it, such as
ansgar's profile image ansgar posted 12 years ago
Ah makes sense, yes. SQL files are opened by doing some load-with-UTF8-encoding-in-mind logic since we have switched to the unicode enabled SynEdit component (the editor itself). I'll check that asap and try to fix that.

Thanks a lot for keeping your good eyes on that issue!

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