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.
>
