Display progress when inserting a large blob

Antti Kurenniemi · Post by **Antti Kurenniemi** » 06.02.2009, 08:42

Hi all.

I have an app where I need to upload files into FB database, and I'd like to be able to display a progress bar while doing so. There's no middle-tier, it's plain Client/Server, so it should be pretty much the progress of the insert query.

...and yes, I'd like to be able to show progress of download (select) as well.

This is using Delphi 2007 and Firebird 1.5.

Any ideas welcome.

fcodebue · Post by **fcodebue** » 07.02.2009, 11:56

mmm

first upgrade to firebird 2.1.1
second you upgrade/download from a LAN or WAN (internet)?
third how do you make upload/download?

Antti Kurenniemi · Post by **Antti Kurenniemi** » 07.02.2009, 21:00

> first upgrade to firebird 2.1.1

No, we'll be sticking with 1.5 for quite a while still. Too large a user base to update right now.

> second you upgrade/download from a LAN or WAN (internet)?

Both. We use the embedded FB and the client/server stuff.

> third how do you make upload/download?

It's just SQL in Delphi, insert into MyBlobTable(blobfield) values... . Typically we read from a file (stream) into the field parameter.

We're not yet using Zeoslib in production, just looking for an alternative to IBO. In IBO, there is an event in the query component to get upload (insert) or download (select) progress as bytes, and it also returns the total bytes, so it's easy enough to calculate and display a progress bar for larger files. So I'm looking for something similar in Zeoslib...?

fcodebue · Post by **fcodebue** » 02.03.2009, 08:34

There's no this kind of features in zeosLib... but you can always write it

It's a very nice feature...