[Valentina] Fwd: Images + REALDatabase + Windows = :(

[Marcel J.G. Trapman]

Hi Ruslan,

I picked this one up in the RB list... Maybe it is wise to comment on 
it!?

Ciao,

Marcel

Begin doorgestuurd bericht:

> Van: Robert Garcia <rgarcia at bighead.net>
> Datum: zat, 18 jan 2003  07:14:27 Europe/Amsterdam
> Aan: "REALbasic Network Users Group" 
> <realbasic-nug at lists.realsoftware.com>
> Onderwerp: Antw.: Images + REALDatabase + Windows = :(
> Antwoord aan: "REALbasic Network Users Group" 
> <realbasic-nug at lists.realsoftware.com>
>
> I have had to build several applications that store and retrieve 
> images to a database. I had to abandon RealDB a long time ago. I first 
> used ValentinaDB, but after the app was shipped for a while, and many 
> photographers were storing thousands of images, I found valentina to 
> be unreliable. If your databases will stay small, Valentina is a great 
> solution. If you need large reliable image database access, use 
> PrimeBase.
>
> Also, you may want to take a look at the miconoJPEG plugin. Try your 
> REALDB methods with it. MiconoJPEG has a method of saving/retrieving 
> JPEGs as strings, which may help.
>
> Also, when using RB and images, try the clipboard workaround if there 
> is a problem. RB sometimes does not treat an image correctly, and a 
> method that is supposed to handle an image will blow up. In RB 3.0, 
> the clipboard workaround had to be used constantly. Now I find that I 
> only have to use it with certain methods. The workaround is 
> accomplished by creating a clip board object and using it as a buffer 
> to your next action.
>
> Add this to your dim code:
> dim clip as clipboard
>
> Then in your method:
> clip = new clipboard
> clip.picture = rs.IdxField(1).JPEGValue
> pointImageCanvas.backdrop = clip.picture
> clip.close
>
> Using the miconoJPEG plugin, or the above workaround may fix your 
> problem, but you will probably have to move to another database.
>
> Robert
>
>
> On Friday, January 17, 2003, at 06:46  PM, Kimball Larsen wrote:
>
>> Why does this work just perfectly on a mac (os 9 or X) but not on any 
>> version of windows?
>>
>>   dim rs as recordSet
>>   dim dbFile as FolderItem
>>   dim db as REALDatabase
>>
>>   db=New REALDatabase
>>   dbFile = GetFolderItem("hinh.dat")
>>   db.DatabaseFile=dbFile
>>   If db.Connect() <> true then
>>     Beep
>>     MsgBox "The image database could not be opened.  Please contact 
>> your vendor."
>>   else
>>     //got the database opened.
>>     rs = db.sqlSelect("select image from images where name = '" + 
>> pointName + "'")
>>     if rs <> nil then
>>       rs.movefirst
>>     else
>>       msgBox "Sorry, a database error occurred.  Please contact your 
>> vendor."
>>     end if
>>     pointImageCanvas.backdrop = rs.IdxField(1).JPEGValue
>>     'pointImageCanvas.Graphics.DrawPicture rs.idxField(1).JPEGValue, 
>> 120, 1
>>     rs.close
>>     db.Close
>>   end if
>>   pointImageCanvas.refresh
>>
>>
>> I just need to be able to pull an image out of a database, and 
>> display it to the user.  Currently, this uses images in jpeg format, 
>> and tries to put them on a CanvasControl as the backdrop...
>>
>> You'll notice that I have also tried the graphics of the Canvas.. 
>> that does not work either.
>>
>> Thanks!
>>
>> --Kimball Larsen
>>
>>
>> ---
>> A searchable archive of this list is available at:
>> <http://support.realsoftware.com/KBDB/search.php>
>>
>> Unsubscribe:
>> <mailto:realbasic-nug-off at lists.realsoftware.com>
>>
>> Subscribe to the digest: 
>> <mailto:realbasic-nug-digest at lists.realsoftware.com>
>>
>>
>
> -- 
>
> Robert Garcia
> BigHead Technology
> 2781 N Carlmont Pl
> Simi Valley, CA 93065
> Phone 805.522.8577
> http://www.bighead.net/
> http://www.theradmac.com/
> rgarcia at bighead.net
>
>
> ---
> A searchable archive of this list is available at:
> <http://support.realsoftware.com/KBDB/search.php>
>
> Unsubscribe:
> <mailto:realbasic-nug-off at lists.realsoftware.com>
>
> Subscribe to the digest: 
> <mailto:realbasic-nug-digest at lists.realsoftware.com>
>
>
Ciao,

Marcel