I have a program that stores data in a Firebird Database and some of the
tables have blob fields.

I have been tasked with writing a front end to the data using html and
script. All would be fine except I have been unable to read the data from
the blob fields with vb.

I can not even get Database Workbench to read them.

I used ISQL and was able to blobdump the data to a text file and that is all
that will be in these fields.

So my question is can someone help me write a sql statement that will export
all the blob fields and create text files named with the table key.

I am thinking something like executing this but it errors in ISQL
FOR A in ISSUES
BLOBDUMP &A.DATA "c:\" + A.ISSUE_NBR + ".txt");
END_FOR;
If I could read and write to these blob fields in VB I would be set
Thanks in advance
--
I have not failed. I have just
found 10,000 ways that don't work.
- Thomas Edison

William Kelleher