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=======================3 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=======================3 D= TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO =======================3D=======================3 D= TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE =======================3D=======================3 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=======================3 D=
