[RBG7-L] - Re: Graphics

[A. Razzak Memon]

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