> > Hi All,
> >
> > I have to provide an export feature which will output all tables and
> > all data to CSV files (one for each table). Is it possible to
> > create text files from within a stored procedure? Better yet, is
> > there a better way to do this?
> >
> > Thanks,
> > Steve
> >
>At 11:22 AM 29/06/2004 +1000, Alan McDonald wrote:
>Use IBO - they have a great export component

Confirmed, it works great for data stored in regular columns.

Be aware of the issues (regardless of how you export data) relating to
blobs. If you have binary blobs (images, PDFs, Word docs, etc.) you can't
pass them to CSV format. If you have text blobs, you'll have to consider
quite a few things, including
1) a way to convert them to strings, e.g. a UDF
2) whether you can guarantee that all of your text blobs CAN be converted
to strings (Firebird's upper limit is 32765 bytes)
3) Size limit on strings for the receiving application. Most will almost
certainly have much lower limits than 32K. (This may also be an issue with
large varchars)

I mentioned this because it's so frequently overlooked in requirements...

/heLen