Helen, Don,

>>IB_Export/IB_Import pair is a better match, but I can't say whether
>>they support text blobs or not since I am away from Delphi at the
>>moment. I guess they do.

H> They don't.

Had to check my facts. Actually IB_Export is able to export blobs into
DBF files only. Unfortunately the IB_Import counterpart is only able to
handle text files. Two shortcomings here: the import component doesn't
handle all the file types the export component is able to generate,
and there's no combination that will allow to transfer the contents of
blob fields (I can imagine more drawbacks for null fields and other
bits, BTW). Sorry Don, unless you fix the components yourself
(supporting text blobs in CSV files might be enough, and that's a
trivial task) you're stucked.

H> But the datapump *is* the equivalent of Don
H> Gollahon's "RawInput" example.

If you can afford to have the two databases online at the same time,
sure, and it has a lot of advantages too, like 2PC. But I fear that
was just an example to show both code fragments... Don, if you don't
need asynchronous transfers then you're back in action with the data
pump component.

H> The IBX I have here doesn't have such a
H> component, but my version is about a year old. It could be something that
H> shipped on the companion CD with Delphi 7 (which I don't have).

Look harder. The TIBInput* and TIBOutput* series are not in the
component palette. Yet you can use them in code.

Ciao
--
Nando Dessena
mailto:nandod@...