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=
