After looking at "Loading Images Using LoadDirectoryName Plugin" I see that my code should have used &vGraphicFile instead of .vGraphicFile.
Thanks, Charlie -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of A. Razzak Memon Posted At: Thursday, August 26, 2004 8:32 AM Posted To: RB7-L Conversation: [RBG7-L] - Re: Graphics Subject: [RBG7-L] - Re: Graphics Charlie, I'll prepare a quick sample for you as soon as I get a free moment! Very Best R:egards, Razzak. At 09:14 AM 8/26/2004 -0500, Charlie Parks wrote: >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. > > >
