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

Snippets

User, date Message
Written by Laban
7 years ago
Category: General
8 posts since Fri, 22 Dec 06
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?
Written by ansgar
7 years ago
4940 posts since Fri, 07 Apr 06
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!
Written by Laban
7 years ago
8 posts since Fri, 22 Dec 06
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
Written by ansgar
7 years ago
4940 posts since Fri, 07 Apr 06
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?
Written by Laban
7 years ago
8 posts since Fri, 22 Dec 06
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
Written by ansgar
7 years ago
4940 posts since Fri, 07 Apr 06
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.