Hi Claudine, As others have mentioned and as I do it myself, it is best to store pictures individually outside the database with just the link stored within the database. The only pictures I store within the database are employee pictures (low resolution) used to generate IDs. Maybe what Jean-Marc is looking for is something like the multi-page tiff format. This file format allows the user to store multiple pages of images (in one file) that can be manipulated individually with widely available specialized editors; this format is often used by scanners. The PDF format would also be a suitable option for storing multiple images in just one file.
Javier, Javier Valencia, PE 913-829-0888 Office 913-915-3137 Cell 913-649-2904 Fax [email protected] -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Claudine Robbins Sent: Wednesday, June 02, 2010 9:30 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Multiple Images Thanks everyone for their input. I will relay this information to Jean-Marc. Have a nice day! Claudine -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Mike Byerley Sent: Wednesday, June 02, 2010 9:13 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Multiple Images Even if the multiple functionality could be added (which would require the creation of a new RBase function for the joining of multiple images on the fly), after said images were stored, what would you use for a retrieval of a specific image buried within the series. This actually suggests a behavior that runs afoul of data normalization, in my view. I also don't see any saving of real estate in the rb4 file by combining the multiple images separate from storing them individually. ----- Original Message ----- From: "Gunnar Ekblad" <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Wednesday, June 02, 2010 9:59 AM Subject: [RBASE-L] - Re: Multiple Images Sounds like an extreme enhancement request. Gunnar Ekblad Kontema IT AB Hästholmsvägen 32 131 30 Nacka Sweden -----Ursprungligt meddelande----- Från: [email protected] [mailto:[email protected]] För [email protected] Skickat: den 2 juni 2010 15:41 Till: RBASE-L Mailing List Ämne: [RBASE-L] - Re: Multiple Images The Blob editor has a tab that allows multiple images to be added or removed from the field data. This editor is probably a program outside of "Rbase" and thus "MAY" not have the ability to use command line parameters. Again, I am assuming here and not stating I know for certain. VARBIT variables do not allow any expressions, such as combining / adding. I.E. Set var vTest VarBit = (.vImage + .vImage1) is not allowed. So I must assume that adding multiple images to a VARBIT type data field via an Rbase command is not available at this time. The reason it can be done via the Blob editor, is that the graphic file is loaded into a program other than Rbase and is manipulated. This program then saves the modified graphic file back into Rbase. -Bob ----- Original Message ----- From: "Claudine Robbins" <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Wednesday, June 2, 2010 8:01:08 AM GMT -06:00 US/Canada Central Subject: [RBASE-L] - Re: Multiple Images Thank you Tony, I concur with your analysis but this is for Jean-Marc Massé and I suspect that this concerns technical drawings that may be small enough to not load the table down. He apparently has it working the way he wants to in terms of display. His question is for loading additional images into a field where images already exist. Claudine -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of A.G. IJntema Sent: Wednesday, June 02, 2010 3:02 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Multiple Images Hi, I don't know how much images you like to load into your database, but in most cases I prefer to store images outside the database and only create a link to them. If it is organized in this way you are able to create a one to many relationship. The many-relationship then contains the link to the specific image. If there are more pictures connected to the master table, you are able to show them in a form or a report Even in the case you like to store pictures in the database itself you can make use of the one - many relationship Succes Tony -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Claudine Robbins Sent: woensdag 2 juni 2010 4:44 To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Multiple Images Thank you Mike. Yes and yes, he using a varbit. This is the code he uses to load one image: SET VAR vimage VARBIT = NULL SET VAR vimage VARBIT = ['\nomdelimage.JPG'] UPDATE tableX SET ChampPhoto = .vimage WHERE condition Now, he would like to add additional images to the same field. Claudine -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Mike Byerley Sent: Tuesday, June 01, 2010 9:35 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Multiple Images Is it multiple images into the same field? BTW, it should be varBit not varChar for images. ----- Original Message ----- From: "Claudine Robbins" <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Tuesday, June 01, 2010 10:22 PM Subject: [RBASE-L] - Multiple Images Hello, Jean-Marc Massé is trying to automate the loading of multiple images into a varchar field. Currently, he successfully adds images with the blob editor but would now like to do it in code. Does anyone have any suggestions for him? TIA, Claudine --- RBASE-L =======================3D======================= D= TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) =======================3D======================= D= TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO =======================3D======================= D= TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE =======================3D======================= D= TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. =======================3D======================= D=
