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