How to deal with a long running Query in forms 6i
Sometimes, your query in forms runs on for ages! Imagine pressing F8 and waiting for
something to turn-up. In most of Microsoft tools, a long running operation normally shows an
alert that informs you that the operation is in progress and also provides you with a cancel
button, in case you want to abandon the operation. Is there any means of interacting with
Forms when a query is executing, like allow user the liberty of cancelling the operation?
Form properties -> Database -> Interaction mode (set it to Non-blocking)
This will show an alert with a cancel button, with the message "Press cancel to end this database
operation". The query fired will run in the background and user can cancel it anytime he/she runs out
of patience.
'Query all records' property takes precedence over this and may suppress the alert if few
records are fetched
This page was created on 01-jan-2002 and last updated on 01-jan-2002.
please forward all queries to amar_padhi@fastmail.fm