At 03:36 PM 1/11/2003 -0500, Bernie Lis wrote:
According to R:Syntax: The recommended data type for images is LONG VARBIT. However in rbdefine there is no long varbit, only varbit. This is ok because when you do "list" it shows up as Long Varbit, I can still insert my image.However, I get an error "Column image must be a valid varbit" when I use a variable for the insert command. When I use insert into images (ID,Image) values (1,['filename.bmp']) it works fine! when I replace 'filename.bmp' with .vfilename, I get the above error. .vfilename comes from: set var vfilename = ('filename' + '.bmp') Can anyone help me with this?
Bernie, From The Edge: Storing Pictures or Graphics as BLOB http://www.razzak.com/fte 07/05/1999 (Blobs) Of course, The Magical R:BASE 7.0 for Windows includes the cool method of Capturing, Storing, Updating, Converting, Viewing and Printing all types of Graphics! Very Best Regards, Razzak.
