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>

Reply via email to