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!
> +
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
