----- Original Message -----
Sent: Friday, August 29, 2003 8:25
PM
Subject: [RBASE-L] - insert images
Can a variable be used as value in a valuelist?
This is what the manual says I should do and it works:
INSERT INTO bilder (ut) VALUES
(['C:/inetpub/wwwroot/Hjortmar/formbilder/220.jpg'])
but this is what I am trying to use:
INSERT INTO bilder (ut) VALUES .vbild
.vbild is a variable that contains the text
(['C:/inetpub/wwwroot/Hjortmar/formbilder/220.jpg'])
I would like to insert images in my database and the images are all in
the same directory.
Being a lazy boy I figured out the following code.
This is my little eep:
SET VAR vtal INTEGER = 219
SET VAR vbild TEXT = ' '
SET VAR
vbildfil INTEGER = 1
SET VAR vfram TEXT = '(['
SET VAR vbak TEXT =
'])'
SET VAR vparfr TEXT = '
SET VAR vparbak TEXT = '
WHILE vtal < 16500 THEN
vbild = 'C:/inetpub/wwwroot/Hjortmar/formbilder/' + (CTXT(.vtal))
+ '.jpg'
vbildfil = (CHKFILE(.vbild))
vbild = .vfram +
.vparfr + 'C:/inetpub/wwwroot/Hjortmar/formbilder/' + (CTXT(.vtal)) + '.jpg' +
.vparbak + .vbak
IF vbildfil = 0 THEN
vbild =
.vbild
ELSE
---*** INSERT INTO bilder
(ut) VALUES (['C:/inetpub/wwwroot/Hjortmar/formbilder/220.jpg'])
***---
---*** A variable containing the same thing as the text above does
not work in an insert command !!! ***---
INSERT INTO
bilder (ut) VALUES .vbild
ENDIF
SET VAR vtal = (.vtal + 1)
ENDWHILE
RETURN
Regards from Christian Hjortmar
+ 46 46 2119142
