Question:
We need to include the capability to abort queries in our Delphi apps that are running under BDE connecting to remote Oracle databases. Occasionally, some queries take a long time to execute, and we would like to give our users the option to cancel a query when this happens. It doesn’t appear that any of the stock data acces components support this capability, nor does this seem readily attainable from the BDE API. I downloaded a component called DBProgress, but it doesn’t seem to work as advertised. Any suggestions?
Answer:
This is admittedly one of the thorns in the sides of many DB app developers. The DBProgress component actually does work, but the BDE doesn’t recognize it for queries – only BatchMoves. I haven’t heard anything from BI regarding this either.