Jeffery,
I wonder if the problem was that I was saving a BMP and not a JPEG?
Do you have a sample project of your code so I can see it work, then I can
dissect it apart to see why mine won't work. I am ready to give up. The DB
works fine for strings, but when I try to save the Picture it just sets
there and locks up, I have to do a Ctrl-Alt-Del to dump the app.
If you tried all my parameters in your code and it works then I must be
doing something wrong for sure, but I have no idea what.
Thanks for all your help...
Jonathon
----- Original Message -----
From: "Jeffrey Martin" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Thursday, October 19, 2006 2:34 PM
Subject: Re: How to save a picture in RealSQLDatabase?
Jonathon:
I tried similar code to yours using my program, writing directly from
the recordset to an imageWell, instead of a canvas like in my
program, and the code worked properly; it did not lock up or crash. I
don't see anything wrong in the code you provided.
Jeffrey
Thinks so much as i got to using your example and it did not
crash. But
when I saved it it did take a sec longer then normal, and when I
tried to
reviem the saved pic it started to get the pic then locked up my
program.
Here is some of my app.
RealSQLDatabase:
// Mind you this is just a short version.
DirectoryDB.SQLExecute "CREATE TABLE Directory (dTradeName VarChar,
dGenericName VarChar, dDrug Blob, dNumber Var Char)"
New/Save SQL Data:
rec.JPEGColumn("dDrug") = mdDrug.image
Update SQL Data:
rs.Field("dDrug").JPEGValue = mdDrug.Image
mdListBox:
// This is apart of the ListBox if the cell is clicked it will then
show all
the data into the editfields.
// NOTE: I have the Picture in an ImageWell, is this right or not?
mdDrug.Image = rs.Field("dDrug").JPEGValue
--------------------------------------------------------------------------------
_______________________________________________
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>
--------------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.408 / Virus Database: 268.13.6/487 - Release Date: 10/19/2006
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.408 / Virus Database: 268.13.6/487 - Release Date: 10/19/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>