A m Z o n e

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

Press the Back button of you Browser to go to previous page
Home