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?
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.