This is what is use to export jpgs from a table in my database to files. Just need to change it to bmp and your tables/columns.
chdir partpic 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 test.dat UNLOAD DATA FOR masterpics USING partpic WHERE part# = .vpartnum OUTPUT SCREEN SET VAR vfile = (.vpartnum + '.jpg') RENAME test.lob .vfile DELETE test.dat FETCH cursor1 INTO vpartnum inv vi1 ENDWHILE DROP CURSOR cursor1 CLS Dan Goldberg From: 'Jim Belisle' via RBASE-L <[email protected]> Sent: Tuesday, July 2, 2024 6:24 AM To: RBase Maillist <[email protected]> Subject: [EXTERNAL] [RBASE-L] - EXPORT bmp FROM rbase TO EXTERNAL FOLDER How can I export BMP files within RBASE to a folder on my hard drive? The gatway export does not have the BMP as an option when exporting using that app. I see one can save each individual BMP to an outside location as a BMP, but that is manual and very time consuming. Any help would be appreciated. James Belisle Making Information Systems People Friendly Since 1990 [cid:[email protected]] -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/PH7PR02MB994301C2F9A8E65F0570B68FA0DC2%40PH7PR02MB9943.namprd02.prod.outlook.com<https://groups.google.com/d/msgid/rbase-l/PH7PR02MB994301C2F9A8E65F0570B68FA0DC2%40PH7PR02MB9943.namprd02.prod.outlook.com?utm_medium=email&utm_source=footer>. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/BY3PR19MB5027AAEFFEA3496CA69EAEA0D4DC2%40BY3PR19MB5027.namprd19.prod.outlook.com.
