Re: Delphi 2.0 and Oracle

Elie Tordjman wrote:

> Hi. I've created several applications in Delphi that access data on
> Oracle7 tables scattered across several servers. It works wonderfully
> and I've managed to impress everyone.
>
> All these applications also come with a generic "Query Tool" that
> allows
> users to do their own queries. Sometimes, though, they will experiment
>
> with a Select statement that can take forever.
>
> Does anybody know how I would go about allowing the user to "Cancel"
> the
> execution of the query, like SQL Plus does?
>
> Query objects in Delphi have an event called OnServerYield, but it
> never
> gets triggered. Does something need to be done on the server side?
>
> Any help would be great. Thanks.

You could at least Close the Database Component the TQuery belongs to. That means in the OnClick of the button
you code

Database->Close();
Database->Open();

Thus you should provide a new TDatabase Component only for the SQL-Tool.

Hope this helps!

Helmut Received on Mon Mar 02 1998 - 00:00:00 CST