Hello all!

I have a problem as I was reading the RL and it said for images and pictures use the BINARY

Set the DB up like this:
DirectoryDB.SQLExecute "CREATE TABLE Directory (dTradeName VarChar, dGenericName VarChar, dDrugPicture Binary)"

To save it I use this:
rec.JpegColumn("dDrugPicture") = mdDrug.image

To view it I do this:
mdDrug.Image = rs.Field("dDrugPicture").JPEGValue

Well, it will not work, so I am not sure if I have it correct or not. And another thing, can I use BMG, GIF or JPEG images to save to the DB? or is there only one type that I can save to it?

A bit lost here, need some help.

Thanks


--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.408 / Virus Database: 268.13.4/478 - Release Date: 10/17/2006

_______________________________________________
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>

Reply via email to