Snippets

User, date Message
Written by Laban
5 years ago
Category: General
7 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
5 years ago
3958 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
5 years ago
7 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

USE contact_se;
SELECT
webuserid as Kundnummer,
first_name as Förnamn,
surname as Efternamn,
job_title as Titel,
company_name as Företag,
department as Avdelning,
address_1 as Adress,
postcode as PostNr,
post_town as Ort,
email as "E-Post",
telephone_number as Telefon,
mobile as Mobil,
fax as Fax
FROM contact WHERE
`deletion_date` IS NULL AND
`status` = 'Live'
ORDER BY Kundnummer ASC
Written by ansgar
5 years ago
3958 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
5 years ago
7 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 åäöëü£¤¥ß. Seems like it only likes A-Z, 0-9.

Edit 2:
Converted failing files to "UTF-8/Unicode Editing" and solved the problem.
Written by ansgar
5 years ago
3958 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.