Devart Forums

I have BLOB field about 15 Megs per field which want to be stored/retrieved via client/server application. My user wants :

1. Information on how much the stream has been stored/retrieved during the process (like progress bar, or something)
2. Cancel progress (in case the user feel the progress is too long, he can cancel the process)

Is that possible to do with postgreDAC ?

Regards,
Eldi Munggaran

Please specify whether your table has BYTEA field or OID field that references to a large object.

If you are using BYTEA, you can load data with the TPgLoader component. In its OnPutData event you can update a progress bar and check if the Cancel button was pressed.

but this should theoretically be possible with oid fields to, you send the BLOB in 64kb Block size nor?

TPgLoader uses COPY command to load data. This command can fill OID fields but it cannot create large objects.