Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.
Course Of The Month
3 days, 15 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
ADO- complete Delphi example
Posted on 2012-12-24
Hello experts,
Problem desc:
- remote Firebird 1.5 server
- 'select * from TABLE'
- 78.567.678.12
- sysdba
- masterkeyxxx
- C:\Database.gdb
- query I am able to cancel at any given time
Question:
How can I do it (using ADO probably) i.e.
TADOConnection
TADODataset (maybe other components)
Thank you!
Problem desc:
- remote Firebird 1.5 server
- 'select * from TABLE'
- 78.567.678.12
- sysdba
- masterkeyxxx
- C:\Database.gdb
- query I am able to cancel at any given time
Question:
How can I do it (using ADO probably) i.e.
TADOConnection
TADODataset (maybe other components)
Thank you!
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2
2-
2
- +2
8 Comments
the query will continue to run on the server, regardless of the client giving up on it, you need at least firebird 2.1 to be able to abort queries
@sedgwick:
I would like to know exactly how to use ADO components to connect to a distant server, run a query but do not necessary wait until it completes- be able to abort the query on client side and/or server side.
@NickUpson:
If possible, could you please point out how to abort query on the client side and on the server side?
My database running on 1.5 but I guess it will be also well working on 2.1 <- am I correct here?
Thank you!
I would like to know exactly how to use ADO components to connect to a distant server, run a query but do not necessary wait until it completes- be able to abort the query on client side and/or server side.
@NickUpson:
If possible, could you please point out how to abort query on the client side and on the server side?
My database running on 1.5 but I guess it will be also well working on 2.1 <- am I correct here?
Thank you!
Why dont you just call TADOConnection .Cancel
Assuming your query is running in some kind of thread and you have the opportunity to call the cancel method
Assuming your query is running in some kind of thread and you have the opportunity to call the cancel method
1.5 does not have a mechanism to stop a query running on the server
2.1 requires you to delete the correct record from rdb$transactions
2.1 requires you to delete the correct record from rdb$transactions
Ok, I am giving up the idea of canceling running query on the server side.
Is there any clever way of canceling query on the client side?
Thank you!
Is there any clever way of canceling query on the client side?
Thank you!
Featured Post
The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Never store passwords in plain text or just their hash: it seems a no-brainier, but there are still plenty of people doing that. I present the why and how on this subject, offering my own real life solution that you can implement right away, bringin…
This article shows the steps required to install WordPress on Azure.
Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan.
WordPress is no exception and requires an App Service Plan and Database to install
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Suggested Courses
Course of the Month3 days, 15 hours left to enroll
691 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.