distal-attribute
distal-attribute
distal-attribute
distal-attribute

Snippets

Laban posted 7 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 posted 7 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 posted 7 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
ansgar posted 7 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 posted 7 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 posted 7 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.