I'm on a window 7 x64 machine, at a cmd.exe prompt. This is what I tried:
C:\jonesqlite3 test2.db3SQLite version 3.8.5 2014-06-04 14:06:34Enter .help
for usage hints.sqlite CREATE TABLE Files (name TEXT PRIMARY KEY,contents
BLOB);sqlite INSERT INTO Files (name,contents) VALUES
Jonathan Leslie wrote:
I'm at a cmd.exe prompt.
sqlite INSERT INTO Files (name,contents) VALUES ('tsql.lis',X$(od -A n -t
x1 tsql.lis|tr -d '\r\n\t '));
Error: near $(od -A n -t x1 tsql.lis|tr -d '\r\n\t '): syntax error
I'm trying to store the file tsql.lis as a blob, and od.exe and
From: Clemens Ladisch clem...@ladisch.de
To: sqlite-users@sqlite.org
Sent: Wednesday, December 3, 2014 1:00 PM
Subject: Re: [sqlite] trying to store a file as a blob. caught on syntax...
Jonathan Leslie wrote:
I'm at a cmd.exe prompt.
sqlite INSERT
select writefile(name, contents) from files where name='filename.ext';
---
Theory is when you know everything but nothing works. Practice is when
everything works but no one knows why. Sometimes theory and practice are
combined: nothing works and no one knows why.
-Original
no such function writefile. do I have to update my sqlite3
C:\jon\svn\SCEPTRE\trunk\SCEPTRE\Scenario Management\ahk_sceptresqlite3
test2.db3
SQLite version 3.8.5 2014-06-04 14:06:34
Enter .help for usage hints.
sqlite select writefile(name,contents) from files where
sqlite .version
SQLite 3.8.5 2014-06-04 14:06:34 b1ed4f2a34ba66c29b130f8d13e9092758019212
sqlite
- Original Message -
From: Jonathan Leslie j...@jonathanleslie.com
To: General Discussion of SQLite Database sqlite-users@sqlite.org
Cc:
Sent: Wednesday, December 3, 2014 8:36 PM
On Wed, Dec 3, 2014 at 8:36 PM, Jonathan Leslie j...@jonathanleslie.com
wrote:
no such function writefile. do I have to update my sqlite3
The writefile() function is built into recent sqlite3.exe command-line
shells. Very recent once, at least.
If you are not using a recent
ahperfect I'm done. Thank you all for all your help.
the latest build of sqlite3 has the readfile and writefile functions in it, and
they seem to be working just fine. here is the cmd.exe session showing what I
did. I was then able to open the image 'i3.png' and it is exactly the