If I try it with my variable vGraphicFile, I get the error message: Column Graphic must be a valid Varbit .
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of A. Razzak Memon Posted At: Thursday, August 26, 2004 8:02 AM Posted To: RB7-L Conversation: [RBG7-L] - Re: Graphics Subject: [RBG7-L] - Re: Graphics At 08:37 AM 8/26/2004 -0500, Charlie Parks wrote: Charlie, Don't convert the variable with "[" and "]" brackets to a VARBIT data type. You'll get garbage. Try the update command using .vGraphicFile variable. UPDATE Conference SET Graphic = .vGraphicFile + WHERE Topic = .fTopic AND SlideNo = .fSlides Variable vGraphicFile includes everything what R:BASE needs to load/update the record. Have fun! Very Best R:egards, Razzak. >It seems to not be allowing me to use variables with graphic files. >Does the name have to be typed instead of using a variable? > >Here is my code: > > PLUGINS Confmac\LoadFileName.RBL vFileName |FullPath ON + > |Title SELECT FILENAME + > |MultiSelect OFF |DONT_ADD_TO_RECENT OFF + > |INITIAL_DIR C:\Documents AND Settings\cp\My Documents\My Pictures + > |OLD_STYLE OFF + > |ENABLE_SIZING ON > > IF vFileName = '[Esc]' THEN > GOTO StopIt > ENDIF --vFileName = '[Esc]' > > SET VAR vGraphicFile = ('[' + (CHAR(39)) + .vFileName + (CHAR(39)) + >']') > > SET VAR vGraphic VARBIT = .vGraphicFile > > UPDATE Conference SET Graphic = .vGraphic + > WHERE Topic = .fTopic AND SlideNo = .fSlides > > >-----Original Message----- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of MikeB >Posted At: Wednesday, August 25, 2004 4:35 PM Posted To: RB7-L >Conversation: [RBG7-L] - Re: Graphics >Subject: [RBG7-L] - Re: Graphics > > > >----- Original Message ----- >From: "Bill Downall" <[EMAIL PROTECTED]> >To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> >Sent: Wednesday, August 25, 2004 4:38 PM >Subject: [RBG7-L] - Re: Graphics > > > > Charles, > > > > Search for "BLOB" in the help. It's under "BLOB Information" > > > > INSERT INTO IMAGES (ID, IMAGEDATA) VALUES + (1, ['filename.bmp']) > >You can also set a variable reference to a graphic as: > >set var vFile varbit = ['SomePathNameToTheGraphicFile'] > >then the full range of data manipulation commands are available: > >update images set imagedata = .vFile where id = 1 and > >INSERT INTO IMAGES ID, IMAGEDATA VALUES + > 1, .vFile > > > > > Bill > > > > > > > > On 25 Aug 2004 at 16:23, Charles Parks wrote: > > > > > If I have the path and filename for a graphic is there a way to > > > load that into the database? > > > > > > I can't seem to find the command that allows this to be done from > > > a command file. > > > > > > I have a form based on a single table view and when I try to use > > > the Note/Blob Field Viewer/Editor it won't let me save the graphic. > >
