I am not sure there is a better way but this is how I get the pictures into a file that is stored in a table.
OUTPUT image.dat UNLOAD DATA FOR masterpics USING partpic WHERE partnumber = .vpartnum OUTPUT SCREEN SET VAR vfile = (.vpartnum + '.jpg') RENAME image.lob .vfile delete image.dat Hope it helps. Dan Goldberg -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Claudine Robbins Sent: Tuesday, July 08, 2008 12:56 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Working with stored images I have: SET VAR VIMAGE VARBIT = ['\IMAGENAME.JPG'] And successfully: UPDATE TABLENAME SET FIELD1 = .VIMAGE WHERE FIELD2 = 1 Now, in an email sending routine, I want to capture the file to attach to an email. So I've tried: SET VAR VGETIMAGE VARBIT = NULL SELECT FIELD1 INTO VGETIMAGE INDICATOR IV1 FROM TABLENAME WHERE FIELD2 = 1 And all I get is: SHOW VAR VGETIMAGE [JPG] What am I missing? Claudine
