#25 BLOBs values dumped not dumped, (NULL), exported (ftBlob)

[solaris]

HiHiHiHi Marciel, thanks for a fine tool, God bless you

When doing the DB dump to any format, the BLOBs values are not dumped, but instead of the value the NULL is in the dump. If exported then there is ftBlob instead of data.

Is there a way to dump the BLOB values as well please?

Thanks, Peter+

[Marciel Degasperi]

Hi Peter,
The SQL syntax does not support exporting blob fields.
If you trying copy a entire table TB1 in database DB1 for another Access database DB2, you can do it with a link.
1- Create a copy of table DB1.TB1 in DB2 (TB1_Copy);
2- Create a link in DB1 for table DB2.TB1_Copy;
3- Copy data with a script like this:

INSERT INTO TB1_Copy
SELECT *
FROM TB1

Or else please explain better what you need so I can try to help.