On Jun 5, 2006, at 12:20 AM, Dr Gerard Hammond wrote:
At 8:57 AM +0200 28/5/06, Marco Bambini wrote:This is a very simple example: // create a dummy table db.SQLExecute("CREATE TABLE images(picture BLOB)") // insert an image into the BLOB column Dim rec As New DatabaseRecord rec.BlobColumn("picture") = GetMyPicture db.InsertRecord ("images", rec) db.CommitHow would I do this via SQL? db.sqlexecute("INSERT into images (picture) values (???????)")
You can't Gerard, the only workaround could be to encode your image with Base64 for example.
Obviously this approach isn't very efficient. --- Marco Bambini http://www.sqlabs.net http://www.sqlabs.net/blog/ _______________________________________________ Unsubscribe or switch delivery mode: <http://www.realsoftware.com/support/listmanager/> Search the archives of this list here: <http://support.realsoftware.com/listarchives/lists.html>
