Client-side status/progress bar???

From: Bryan Dollery <bryan_at_bryan.prestel.co.uk>
Date: 1997/07/12
Message-ID: <33C80763.7674CF5C@bryan.prestel.co.uk>#1/1

This is a multi-part message in MIME format.
--------------756C0742AD42E0F5D93305EA

Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit

Hi (again)

I am writing an application. It has a VB front end (very pretty), and a pl/sql engine on an oracle 7.1 server as the back end (very powerful).

The VB code initiates a PL/SQL routine which goes away an processes possibly hundreds of thousands of records. This takes time.

I would like the VB app to display a progress bar, but there are two problems:

The server routine exclusively uses updateable cursors.
The VB app blocks awaiting the end of the server routines.

The first problem means that there can be no commits, and therefore a progress table can't be updated, and then asynchronously read by VB.

The second problem means that even if there were a solution to the first problem, the second problem would make it redundant.

Just to make things worse. The VB app is running under a 16bit MS-Windows environment, and therefore I can't simply strip off another thread to initiate the procedure, and hence solve the second problem.

Does anyone have any ideas how to sort this out?

Bryan

Bryan Dollery BSc.(Hons).
MD - ByteSmart Systems Ltd.
--------------756C0742AD42E0F5D93305EA

Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Bryan Dollery
Content-Disposition: attachment; filename="vcard.vcf"

begin:          vcard
fn:             Bryan Dollery
n:              Dollery;Bryan
org:            ByteSmart Systems Ltd.
adr:            ;;;;;;England
email;internet: bryan_at_bryan.prestel.co.uk
note:           Consultant Software Engineer

=0A=
B.Sc. (Hons). Software Engineering
=0A=
MD - ByteSmart Systems Ltd.
x-mozilla-cpt: ;0
x-mozilla-html: TRUE
end: vcard

--------------756C0742AD42E0F5D93305EA--
Received on Sat Jul 12 1997 - 00:00:00 CDT