asked on
ADO- complete Delphi example
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!
DelphiDatabases
Last Comment
developmentguru
can u be more clear as for what do you wish to see in the example?
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
ASKER
@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
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
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!
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.