OK....MANY THANKS....
Daniele
----- Original Message -----
From: Dan Goldberg
To: RBASE-L Mailing List
Sent: Tuesday, June 16, 2009 2:37 PM
Subject: [RBASE-L] - RE: Export images from table to file
Here is a snippet of code I use to extract images from a table. Hope it helps.
SET VAR vpartnum TEXT
DECLARE cursor1 CURSOR FOR SELECT part# FROM masterpics ORDER BY part#
OPEN cursor1
FETCH cursor1 INTO vpartnum inv vi1
WHILE SQLCODE <> 100 THEN
PAUSE 4 USING .vpartnum
OUTPUT image.dat
UNLOAD DATA FOR masterpics USING partpic WHERE part# = .vpartnum
OUTPUT SCREEN
SET VAR vfile = (.vpartnum + '.jpg')
RENAME image.lob .vfile
delete test.dat
FETCH cursor1 INTO vpartnum inv vi1
ENDWHILE
DROP CURSOR cursor1
------------------------------------------------------------------------------
From: [email protected] [mailto:[email protected]] On Behalf Of R:Daniele
Sent: Tuesday, June 16, 2009 5:21 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Export images from table to file
Hello
there is a way to export images (long varbit) from a table to a file (bmp,
jpg..) ?
I'm using R:BASE 7.6 last update
TIA
Daniele
