Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Alt-Tab in a Form

Alt-Tab in a Form

From: S. Johnson <scjonson_at_fyiowa.infi.net>
Date: 1996/12/20
Message-ID: <32BB70AF.2BD9@fyiowa.infi.net>#1/1

I'd like to know if anyone knows how to make a form non-blocking so you can ALT-Tab out of it.

   Here's my problem: I have an application which runs queries against a database joining tables with data anywhere from 400,000 to 2 million each. When the query is being executed the form get's locked and all the user can do is sit and wait until the query is done. Sometimes this takes several hours. The queries aren't just Select's there also updates and inserts. SQL Net 2.xx doesn't block your system during Select statements but it still does while doing Insert's and Updates.

   The only thing that I can think of right now is to batch them off using a stored procedure to call Oracle's new batch builtins in Pl/Sql DBMS_JOB. This isn't exactly what I wanted to do but it's the only thing that I can think of. If anyone knows of anything else I'd sure appreciate.

                Thanks

            Steve J. Received on Fri Dec 20 1996 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US