Maybe I missed something.....
set var vImage long varchar = ['SomePathNameOfGraphicFile']
insert into ScannedFiles +
IDNUM,INPUTDATE,FILEDES,SFILENAME, SCANFILENAM +
values +
786, 122902, 'Problem SCAN3 file to view.', .vc_tiff , .vImage
works for me W/O the write gymnastics.
----- Original Message -----
From: "Alastair Burr" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[EMAIL PROTECTED]>
Sent: Tuesday, December 31, 2002 3:41 PM
Subject: [RBASE-L] - Re: Using the Insert Command
> Duey,
>
> What I do - and there must also be an easier way! - is set quotes to " | "
> then create the text then set quotes back to " ' ".
> You have watch your typing, though!!
>
> Regards,
> Alastair.
>
> ----- Original Message -----
> From: "Duey Heffelfinger" <[EMAIL PROTECTED]>
> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]>
> Sent: Tuesday, December 31, 2002 6:09 PM
> Subject: [RBASE-L] - Re: Using the Insert Command
>
>
> > Ok Ben, if I understand your need correctly, I've done this in the
> > past.
> >
> > --Tiff Variable
> > SET VAR vc_tiff TEXT = 'scan3.tif'
> > --Insert statement into command file
> > OUTPUT temp.cmd
> > WRITE 'INSERT INTO ScannedFiles +'
> > WRITE '(IDNUM,INPUTDATE,FILEDES,SFILENAME, SCANFILENAM) +'
> > WRITE ' VALUES (786,122902, +'
> > SET VAR vc_insert = +
> > (CHAR(39) + 'Problem SCAN3 file to view.' + CHAR(39) + ', +')
> > WRITE .vc_insert
> > SET VAR vc_insert = +
> > (CHAR(39) + .vc_tiff + CHAR(39) + ', +')
> > WRITE .vc_insert
> > SET VAR vc_insert = +
> > ('[' + CHAR(39) + .vc_tiff + CHAR(39) + '])')
> > WRITE .vc_insert
> > OUTPUT SCREEN
> > --To run
> > RUN temp.cmd
> >
> > I'm sure there must be a simpler way, but the quotes required inside
> > the bracket always seemed to cause me sufficient headaches that I
> > used this solution. If the INSERT was a less complicated statement I
> > would have placed the entire command in a variable and run the
> > variable as &vc_insert instead of creating a temporary command file.
> > In this case the expression got too long so I went the temporary
> > command route.
> >
> > I'd be interested to know if this was what you are looking for.
> > Happy New Year!
> >
> > Duey
> >
> > >
> > > I am using the insert command to insert a file, such as *.jpg or *.tif
> > > files. When using this example
> > >
> > > INSERT INTO ScannedFiles
> > > (IDNUM,INPUTDATE,FILEDES,SFILENAME,SCANFILENAM) VALUES
> > > (786,122902,'Problem SCAN3 file to view.','SCAN3.TIF', ['SCAN3.TIF'])
> > >
> > > Is there anyway to place the ['SCAN3.TIF'] in some type of variable
> > > and use in a command file?
> > >
> > > Benjamin Strickland
> > >
> >
> > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> > + Duey Heffelfinger, Director of Computer Services
> > +
> > + E-mail: [EMAIL PROTECTED] Dana College
> > +
> > + Phone : 402-426-7289 2848 College Drive
> > +
> > + Blair, Nebraska 68008
> > +
> > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> > + If you can dream it, it can come true!
> > +
> > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> >
>
>
