Re: [sqlite] Seemingly random Access Violation errors

Matthew Dumbleton wrote: > > Joe, I have tried sending the attachment to you direct but I guess > otherwise the answer to.. > I received the attachment and I'll look into it. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Seemingly random Access Violation errors

Oh. Joe, I have tried sending the attachment to you direct but I guess otherwise the answer to.. 'Could you provide some sample C# code that demonstrates the issue?' -- Joe Mistachkin ...is, no. On 03/10/2012 14:25, Simon Slavin wrote: On 2 Oct 2012, at 7:40pm, Matthew Dumbleton

Re: [sqlite] Custom SQL functions and "nullvalue"

On 10/3/12 4:20 AM, "Richard Hipp" wrote: >On Tue, Oct 2, 2012 at 5:12 PM, Duquette, William H (318K) < >william.h.duque...@jpl.nasa.gov> wrote: > >> Howdy! >> >> The SQLite3 Tcl interface has a "nullvalue" command, which determines >>how >> NULLs are represented as Tcl values.

Re: [sqlite] Right way to store binary data into a blob

On 03 Oct 2012 at 10:50, Clemens Ladisch wrote: > Tim Streater wrote: >> What's the right way to get the data into the column? > > 1) Use SQLite blob literals, which are hex strings with an "x" prefix: > > ... set imagedata = x'ffd8ffe000104a46...' where ... > > 2) Use

Re: [sqlite] Seemingly random Access Violation errors

On 2 Oct 2012, at 7:40pm, Matthew Dumbleton wrote: > I have attached a small project Sorry but attachments don't work with posts to this list. We don't want everyone sending us their homework and killing our byte caps. Could you put your work on a server somewhere and

Re: [sqlite] Right way to store binary data into a blob

On 3 Oct 2012, at 9:33am, Tim Streater wrote: > I've got a temporary database with a blob column. I'm using the PHP PDO > interface, and I'd like to store some binary data into the blob; it's > actually an image. Later I'm going to read it back and write it to disk. >

Re: [sqlite] Seemingly random Access Violation errors

I have attached a small project with which you should be able to see the issue I am having. Thanks in advance for taking the time to look. On 26/09/2012 23:47, Joe Mistachkin wrote: Matthew Dumbleton wrote: Sorry, should have highlighted this better in my initial message. Started out using

Re: [sqlite] Custom SQL functions and "nullvalue"

On Tue, Oct 2, 2012 at 5:12 PM, Duquette, William H (318K) < william.h.duque...@jpl.nasa.gov> wrote: > Howdy! > > The SQLite3 Tcl interface has a "nullvalue" command, which determines how > NULLs are represented as Tcl values. If you do a query on a NULL value, > you get the "nullvalue" value.

Re: [sqlite] Right way to store binary data into a blob

Tim Streater wrote: > I've got a temporary database with a blob column. I'm using the PHP > PDO interface, and I'd like to store some binary data into the blob; > it's actually an image. > At the moment I'm using str_replace to change any single-quote to two > single-quotes, and then doing as

[sqlite] Right way to store binary data into a blob

I've got a temporary database with a blob column. I'm using the PHP PDO interface, and I'd like to store some binary data into the blob; it's actually an image. Later I'm going to read it back and write it to disk. What's the right way to get the data into the column? At the moment I'm using

Re: [sqlite] Subtract times hh:mm:ss

Hi Olaf, Thanks, will give that a try today and tell you if it is faster. RBS On Wed, Oct 3, 2012 at 3:55 AM, Olaf Schmidt wrote: > Am 02.10.2012 21:23, schrieb Bart Smissaert: > >> Nice one, thanks for that. > > > Just in case you use the COM-Wrapper - and this operation