On 23 Mar 2012, at 4:29pm, Nigel Verity <nigelver...@hotmail.com> wrote:
> I'm new to SQLite, coming from an Access/VB background. Having moved over to > Linux I'm now developing an application using Gambas. One of the requirements > is to store a scanned document (PDF) in a record as a blob, along with its > metadata. I've no problem selecting the document, but I'm struggling to work > out how to assign it to the blob field. Does anybody have any tips or, > possibly, the URL of a site that could assist? A blob stores a sequence of bytes. The bytes can represent anything you like. So you could, for example, read in a PDF file and store the bytes of that file in a BLOB. You'll probably want to store the file's name in another column, too. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users