No you missed nothing, different horses for different courses, I guess.
Regards,
Alastair.
----- Original Message -----
From: "MikeB" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[EMAIL PROTECTED]>
Sent: Tuesday, December 31, 2002 9:05 PM
Subject: [RBASE-L] - Re: Using the Insert Command
> 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!
> > > +
> > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> > >
> >
> >
>
